User guide

Formatting a Report
Developing an ENFORM Query
3–46 058058 Tandem Computers Incorporated
Printing Information at the Bottom of Every Report Page
Use either SUBFOOTING or FOOTING to specify printing of information at the
bottom of each page of a report. If both are specified, the information specified for
FOOTING is printed below the information specified for SUBFOOTING.
The FOOTING and SUBFOOTING statements are session wide; they apply to all
reports generated during the current ENFORM session unless they are cancelled, reset,
or overridden. The SUBFOOTING and FOOTING clauses temporarily override the
SUBFOOTING and FOOTING statements for the report generated by the associated
LIST statement.
The following query contains both a FOOTING and SUBFOOTING statement.
TITLE " Order Summary";
SUBFOOTING "Summary of";
FOOTING "Orders For " ordernum;
OPEN order,odetail,parts;
LINK order TO odetail VIA ordernum;
LINK parts TO odetail VIA partnum;
LIST BY order.ordernum, FORM,
custnum, parts.partnum,
quantity,price;
Report:
Order Summary
Part
ORDERNUM CUSTNUM Number QUANTITY PRICE
-------- ------- ------ -------- ---------
21 1234 244 1 87000.00
2001 2 1500.00
Summary of
Orders For 21
Order Summary
Part
ORDERNUM CUSTNUM Number QUANTITY PRICE
-------- ------- ------ -------- ---------
25 7777 244 1 87000.00
6301 2 2900.00
6402 10 1500.00
Summary of
Orders For 25
...