OVERVIEW.............An Overview of the Report and Label Form Editors
REPORT EDITOR........The Report Editor Main Menu
OPEN DATABASE........Opening Databases to be used for the Report
LOAD FORM............Loading a Report Form File for Editing
CREATE REPORT........Creating a New Report Form File
REPORT LAYOUT........Editing the Layout of the Columnar Report
REPORT COLUMNS.......Editing the Columns of the Report
TEST REPORT..........Test-Output of the Report
LABEL EDITOR.........The Label Form Editor Main Menu
OPEN DATABASE........Opening Databases to be used for the Labels
LOAD FORM............Loading a Label Form File for Editing
EDIT LAYOUT..........Editing the Label Parameters
OVERVIEW
An Overview of the Report and Label Form Editors
Description:
The Report Editing system consists of a Report Form (.FRM)
editor and a Label Form (.LBL) editor.
The Report Form editor can be invoked by the following
methods:
1. From the Database Assistant EDIT menu, select "Modify
a Report Form".
2. From the Report Manager menu, select the Report in the
pick-list, then press (F) to Edit the Form.
3. From the Dot Prompt, use the command:
. MODIFY REPORT (form)
The Report Form Editor creates and modifies .FRM files
which are used to design the format of columnar reports
that use data from parent and child work areas.
The Label Form editor can be invoked by the following
methods:
1. From the Database Assistant EDIT menu, select "Modify
a Label Form".
2. From the Report Manager menu, select the Report in the
pick-list, then press (F) to Edit the Form.
3. From the Dot Prompt, use the command:
. MODIFY LABEL (form)
The Label Form Editor creates and modifies .LBL files
which are used to design the print format on continuous
labels from parent and child work areas.
See Also:
MODIFY REPORT
dc_frmmodify()
MODIFY LABEL
dc_lblmodify()
REPORT EDITOR
The Report Editor Main Menu
Description:
The Report Form editor main menu displays the name of the
form file being edited and the work area in use.
旼컴컴컴컴컴컴캑 ** REPORT FORM EDITOR ** 쳐컴컴컴컴컴컴컴�
� �
� Editing REPORT File: C:\CUSTOMER\CUSTOMER.FRM �
� Data File Selected : C:\CUSTOMER\CUSTOMER.DBF �
� �
� 旼캑 EDITING OPTIONS 쳐컴� �
� � Open/Select a Data File � �
� � Load a Report File � �
� � Edit Report Layout � �
� � Edit Report Columns � �
� � Create a New Report File � �
� � Save Report File � �
� � Test Report Form � �
� � Quit and Save File � �
� 읕컴컴컴컴컴컴컴컴컴컴컴컴켸 �
� �
읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴�
See Also:
MODIFY REPORT
dc_frmmodify()
OPEN DATABASE
Opening Databases to be used for the Report
Description:
It is not necessary to open a database file when creating
or editing a .FRM file, however it is recommended that the
parent and child databases be opened and relations set
before editing the report. This will provide a pick-list
of parent and child fields to be used in the report.
You may open databases in one of several methods:
1. The USE command from the Dot-Prompt.
2. From a WORK (.DCW) file referenced by the Report
Manager.
3. By choosing "Open/Select a Data File" from the Report
Editor menu.
See Also:
MODIFY REPORT
dc_frmmodify()
LOAD FORM
Loading a Report Form File for Editing
Description:
You must first load the .FRM file you wish to edit into
memory before it can be modified. This is accomplished by
one of several methods:
1. Passing the name of the Report Form file to the editor
from the Dot Prompt as follows:
. MODIFY REPORT (form name)
2. The name of the file is passed to the Report Editor by
the Report Manager.
3. Choosing "Load a Report File" from the Report Editor
menu.
If no extension is included in the form name then .FRM will
be used. If no path is included in the form name then the
file will be created in the DEFAULT directory.
See Also:
MODIFY REPORT
dc_frmmodify()
CREATE REPORT
Creating a New Report Form File
Description:
Creating a new form file is accomplished by one of several
methods:
1. Passing the name of the Report Form file to the editor
from the Dot Prompt as follows:
. MODIFY REPORT (form name)
2. The name of the new file is passed to the Report Editor
by the Report Manager.
3. Choosing "Create a Report File" from the Report Edit
menu.
If the form does not exist it will be created, if it does
exist it will be overwritten. If no extension is included
in the form name then .FRM will be used. If no path is
included in the form name the the file will be created in
the DEFAULT directory.
See Also:
MODIFY REPORT
dc_frmmodify()
REPORT LAYOUT
Editing the Layout of the Columnar Report
Description:
The report layout editing screen defines the general
layout of the report including headings, margins, lines
per page, and sub-grouping information.
旼컴컴컴컴� Editing REPORT FILE: RCVABLES.FRM 쳐컴컴컴컴커
� PAGE HEADER: �
� ** Receivables List ** �
� �
� �
� �
� �
� FORMATTING: PRINTER DIRECTIVES: �
� Page Width 80 Page Eject Before Print Y �
� Left Margin 3 Page Eject After Print Y �
� Right Margin 0 Plain Page N �
� Lines Per Page 58 �
� Double Spaced? N �
� �
� GROUP SPECIFICATIONS: Press ALT-F for field list �
� Group On Expression CUST_NMBR �
� Group Heading Customer Number �
� Summary Report Only N �
� Page Eject After Group Y �
� �
� SUB-GROUP SPECIFICATIONS: Press ALT-F for field list �
� Sub-Group On Expression �
� Sub-Group Heading �
읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴켸
-- PAGE HEADER --
Up to four lines of heading information can be included in
the report. The heading will be printed on each page of
report.
-- FORMATTING --
Enter the page width, left/right margins, number of lines
per page, and whether you wish a blank line between records
printed on the report.
-- PRINTER DIRECTIVES --
Enter Y or N for Page Eject options. Enter Y for "Plain
Page" if you do not want page numbers to be printed on each
page of the report.
-- GROUP SPECIFICATIONS --
A "Group On Expression" if entered, will group the records
together on the report based on any specified expression.
For example, if your database is indexed on the Customer
Number, and you are printing a status of all open invoices,
you may wish to group on CUST_NMBR. When the value of
CUST_NMBR changes during the printing of the report, a
sub-heading and sub-total will be printed. Enter Y for
"Summary Report" you wish only the sub-total information
to be printed instead of the detailed columnar information.
-- SUB-GROUP SPECIFICATIONS --
A "Sub-Group On Expression" if entered, will sub-group the
records together on the report based on any specified
expression.
See Also:
MODIFY REPORT
dc_frmmodify()
REPORT COLUMNS
Editing the Columns of the Report
Description:
To edit the columns of the report select "Edit Report
Columns" from the Report menu. The column editor will
definition of the information to include in columns on the
printed report. See the below example.
旼컴컴컴캑 Editing Report Columns: BASEBALL.FRM 쳐컴컴컴컴�
� �
� Column Header Contents Width Dec Tot �
� �
� 1 Player Name PLAYER 20 0 N �
� 2 Team Name TEAM 15 0 N �
� 3 League LEAGUE 6 0 N �
� 4 Original;Price ORIG_PRICE 10 2 Y �
� 5 Present;Value PRES_VALUE 10 2 Y �
� 6 Profit PRES_VALUE-ORIG_PRICE 10 2 Y �
� �
� �
읕컴컴 Edit Add Insert Delete Test Save/Exit 컴컴켸
-- COLUMN --
The column number is the numeric ordinal position of the
column in the report, not the physical location.
-- HEADER --
The HEADER is a descriptor for each column. If the header
is longer than the column width, it will wrap around and use
the number of lines required to fit into the report.
-- CONTENTS --
The CONTENTS is an expression that is evaluated for each
record in the report. If the output of the evaluation is
longer than the column width, it will wrap around and use
the number of lines required to fit into the report.
-- WIDTH --
The WIDTH is a numeric value defining the number of screen
or printer columns to use for the report. The total width
of the report will be the sum of the widths of each column
plus one blank space between columns.
-- DEC --
DEC is the number of decimal locations to include in the
printout of columns which evaluate as numeric.
-- TOT --
TOT if Y (yes) will list totals at the end of the report
and at the end of each sub-group for columns which evaluate
as numeric.
MENU OPTIONS
The menu bar at the bottom of the window displays the
column editing options:
-- EDIT --
To edit a column, first select the column in the display
then press (E). When editing the CONTENTS field you may
press key (ALT-F) for a pick-list of database fields from
the parent and child work areas.
-- ADD --
To add a column, press (A) then fill in the column
information. The maximum number of columns in any report
is 22.
-- INSERT --
To insert a column, first select a column in the display
then press (I). A new column will be inserted in front
of the selected column. Fill in the information in the
same manner as adding or editing a column.
-- DELETE --
To delete a column, first select a column in the display
then press (D).
-- TEST --
This selection will output the columnar information to
the display to aid in determining whether the report
columns display the information as desired.
-- SAVE/EXIT --
This selection will save the edited column information in
memory (not in the form file) and return to the main
Report Editor menu.
See Also:
MODIFY REPORT
dc_frmmodify()
TEST REPORT
Test-Output of the Report
Description:
After creating a report form, it can be tested by
outputting the data to the display. If the displayed
information is not satisfactory, it can be re-edited before
saving it to the file.
See Also:
MODIFY REPORT
dc_frmmodify()
LABEL EDITOR
The Label Form Editor Main Menu
Description:
The Label Form editor main menu displays the name of the
form file being edited and the work area in use.
旼컴컴컴컴컴컴캑 ** LABEL FORM EDITOR ** 쳐컴컴컴컴컴컴컴�
� �
� Editing LABEL File : C:\CUSTOMER\CUSTOMER.LBL �
� Data File Selected : C:\CUSTOMER\CUSTOMER.DBF �
� �
� 旼캑 EDITING OPTIONS 쳐� � �
� � Open/Select a Data File � �
� � Load a Label File � �
� � Edit Label Parameters � �
� � Create a New Label File � �
� � Save Label File � �
� � Quit and Save File � �
� 읕컴컴컴컴컴컴컴컴컴컴컴컴켸 �
� �
읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴켸
See Also:
MODIFY LABEL
dc_lblmodify()
OPEN DATABASE
Opening Databases to be used for the Labels
Description:
It is not necessary to open a database file when creating
or editing a .LBL file, however it is recommended that the
parent and child databases be opened and relations set
before editing the report. This will provide a pick-list
of parent and child fields to be used in the report.
You may open databases in one of several methods:
1. The USE command from the Dot-Prompt.
2. From a WORK (.DCW) file referenced by the Report
Manager.
3. By choosing "Open/Select a Data File" from the Label
Editor menu.
See Also:
MODIFY LABEL
dc_lblmodify()
LOAD FORM
Loading a Label Form File for Editing
Description:
You must first load the .LBL file you wish to edit into
memory before it can be modified. This is accomplished by
one of several methods:
1. Passing the name of the Label Form file to the editor
from the Dot Prompt as follows:
. MODIFY LABEL (form name)
2. The name of the file is passed to the Label Editor by
the Report Manager.
3. Choosing "Load a Label File" from the Label Editor menu.
If no extension is included in the form name then .LBL will
be used. If no path is included in the form name then the
file will be created in the DEFAULT directory.
See Also:
MODIFY LABEL
dc_lblmodify()
EDIT LAYOUT
Editing the Label Parameters
Description:
The format of the labels is established by filling in
the information in the "Edit Label Parameters" screen.
An example is shown below:
旼컴컴컴컴캑 Editing LABEL FILE: CUSTOMER.LBL 쳐컴컴컴컴커
� �
� DIMENSIONS: FORMATTING: REMARKS: �
� Width 35 Lines 1 3 1/2 x 15/16 by 2 �
� Height 5 Spaces 2 �
� Across 2 Margin 0 �
� �
� Line 1 "Accounts Receivable" �
� Line 2 BILL_NAME �
� Line 3 BILL_STRT �
� Line 4 TRIM(BILL_CITY)+" "+BILL_STATE+BILL_ZIP �
� Line 5 "Attn: "+CONTACT �
� Line 6 �
� Line 7 �
� Line 8 �
� Line 9 �
� Line 10 �
� Line 11 �
� Line 12 �
� Line 13 �
� Line 14 �
� Line 15 �
� Line 16 �
읕컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴컴켸
-- DIMENSIONS --
The WIDTH is the number of printer columns for each label.
The HEIGHT is the number of printer lines for each label.
ACROSS is the number of labels across the page.
-- FORMATTING --
LINES is the number of blank lines between labels down
the page.
SPACES is the number of blank columns between labels
across the page.
MARGIN is the left print margin when printing the left-
most label.
-- REMARKS --
This is a comment field only and is not printed in the
labels.
See Also:
MODIFY LABEL
dc_lblmodify()