SQL/MX Report Writer Guide

Customizing a Report
HP NonStop SQL/MX Report Writer Guide—527194-002
4-26
Break Footings
Break Footings
You can specify a break footing for each break group. You can have more than one
BREAK FOOTING command in effect at a time, but each command must relate to a
different break column.
A break footing can include:
•
Columns from the select list
•
Named print items from the DETAIL print list
•
String literals
•
Arithmetic expressions
If a column identifier is used as a print item in a BREAK FOOTING command, the
value for that item is taken from the last detail line of the break group.
You must enclose the print list of a BREAK FOOTING command in parentheses.
You can delete the break title associated with each specified break column by using
the RESET REPORT BREAK FOOTING ( column-list) command.
To include an unnamed item from the detail line in a break footing, you must define a
detail alias name for the item.
In this example, a report generates break footings for two break groups—one for each
customer and one for each order:
>> SELECT *
+> FROM CUSTOMER C, ORDERS R, ODETAIL OD
+> WHERE C.CUSTNUM = R.CUSTNUM
+> AND R.ORDERNUM = OD.ORDERNUM
+> ORDER BY C.CUSTNUM, R.ORDERNUM, DELIV_DATE DESC;
S> DETAIL CUSTNAME NOHEAD, SPACE 5,
Figure 4-11. A Page Footing
21 CENTRAL UNIVERSITY
UNIVERSITY WAY
PHILADELPHIA, PENNSYLVANIA
123 BROWN MEDICAL CO
..
..
..
7777 SLEEPWELL HOTELS
9000 PETERS AVENUE
DALLAS, TEXAS
Customer 7777
Page 4
VST0411.vsd