SQL/MP Report Writer Guide

Customizing a Report
HP NonStop SQL/MP Report Writer Guide—527213-001
4-23
Labeling Information
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.
You can include columns from the select list, named print items from the DETAIL print
list, string literals, and arithmetic expressions in a footing. If you want 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.
There is only one REPORT FOOTING and one PAGE FOOTING command 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, the following commands specify that the page footing
includes the customer number:
>> SET STYLE HEADINGS OFF;
>> SELECT *
+> FROM SALES.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