User guide

Formatting a Report
Developing an ENFORM Query
3–54 058058 Tandem Computers Incorporated
Report:
CUSTNUM CUSTNAME CITY
------- ------------------ --------------
21 CENTRAL UNIVERSITY PHILADELPHIA
123 BROWN MEDICAL CO SAN FRANCISCO
143 STEVENS SUPPLY DENVER
324 PREMIER INSURANCE LUBBOCK
543 FRESNO STATE BANK FRESNO
Setting a Tab for a Report
Use the TAB clause to define where the next element is to be printed in a report line.
The default column spacing resumes after the element is printed. A digit following the
keyword TAB indicates the column number in which the element is printed.
Remember that the digit specified in a TAB clause is always relative to the left margin
setting and always on the current line even if ENFORM must backspace to reach the
specified column. If no digit is specified in a TAB clause, column 1 is assumed.
In the following example, the TAB clause causes ENFORM to print city in column 50:
OPEN customer;
LIST custnum, custname,TAB 50, city;
Report:
CUSTNUM CUSTNAME CITY
------- ------------------ ------------
21 CENTRAL UNIVERSITY PHILADELPHIA
123 BROWN MEDICAL CO SAN FRANCISCO
143 STEVENS SUPPLY DENVER
... ... ...
Formatting the Appearance
of Selected Information
Formatting the information you select for your report makes the report both useful
and visually pleasing. ENFORM provides clauses that allow you to:
Temporarily change the display format of an element.
Print a time value on a report.
Print a data value on a report.
Table 3-8 shows these clauses.
Table 3-8. Clauses Used to Format Selected Information
Clause Function
AS Temporarily overrides the display format for printing the value of a element.
AS DATE Temporarily converts a date from internal format to a display format for printing.
AS TIME Temporarily converts a time form internal format to a display format for printing.