User guide

Formatting a Report
Developing an ENFORM Query
058058 Tandem Computers Incorporated 3–45
Printing Information at the Beginning or End of a Report
Specify AT START or AT END to print one or more lines of user-defined information
at the beginning (AT START) or at the end (AT END) of a report. The session-wide AT
START statement prints information directly after the title (if any) on the first page of
every report in the current ENFORM session unless cancelled, reset, or overridden.
The AT END statement prints information on the last page of every report in the
current ENFORM session unless cancelled, reset, or overridden. Refer to the ENFORM
Reference Manual for information about cancelling or resetting these statements. The
AT START and AT END clauses temporarily override the AT START and AT END
statements respectively. Consider the following queries:
AT START PRINT "Confidential Report";
AT END PRINT"End of Confidential Report";
OPEN employee;
LIST empname, salary;
CLOSE employee;
OPEN parts;
LIST partnum,partname,price,
AT START PRINT"Parts Report",
AT END PRINT"End of Parts Report";
Report generated by first query:
Confidential Report
EMPNAME SALARY
------------------ ------
ROGER GREEN 39500
JERRY HOWARD 37000
JACK RAYMOND 36000
... ...
End of Confidential Report
Report generated by second query:
Parts Report
Part
Number PARTNAME PRICE
------ ------------------ ---------
212 SYSTEM 192KB CORE 92000.00
244 SYSTEM 192KB SEMI 87000.00
1403 PROC 96KB SEMI 22000.00
... ... ...
7301 POWER MODULE 2400.06
End of Parts Report