SQL/MX Report Writer Guide

Customizing a Report
HP NonStop SQL/MX Report Writer Guide—527194-002
4-25
Page and Report Footings
A blank line separates the body of the report from the page footing. On the last page,
the report footing is separated from the body of the report by a blank line. The other
pages of the report do not contain the report footing.
A footing can include:
•
Columns from the select list
•
Named print items from the DETAIL print list
•
String literals
•
Arithmetic expressions
To include in a footing the value of an unnamed item from the detail line, you must
define a detail alias name for the item.
Only one REPORT FOOTING and one PAGE FOOTING command are in effect at a
time. You can edit a command by using FC, replace a command by reentering it, or
delete a command by using RESET REPORT.
If a column identifier is used as a print item in a footing, the value for that item is taken
from the last detail line on the page (for page titles) and the last detail line of the report
(for report titles). For example, to specify that the page footing includes the customer
number, enter:
>> SET STYLE HEADINGS OFF;
>> SELECT *
+> FROM CUSTOMER
+> ORDER BY CUSTNUM;
S> DETAIL CUSTNUM, CUSTNAME, SKIP 1,
+> TAB 10, STREET, SKIP 1,
+> TAB 10, CONCAT (CITY STRIP, ', ', STATE),
+> SKIP 1;
S> PAGE FOOTING 'Customer ', CUSTNUM, TAB 50,
+> 'Page ', PAGE_NUMBER AS I2 ;
S> LIST ALL;
Figure 4-11 shows the report. The customer number is taken from the last output row
on the page.
Figure 4-10. Location of Report and Page Footings
.
.
(The body of the report ends here.)
End of Summary
Page 3
VST0410.vsd