SQL/MX Report Writer Guide

Customizing a Report
HP NonStop SQL/MX Report Writer Guide—527194-002
4-22
Break Titles
Break Titles
You can specify a break title for each break group. You can have more than one
BREAK TITLE command in effect at a time, but each command must relate to a
different break column.
In a break title, you can include:
•
Columns from the select list
•
Named print items from the DETAIL print list
•
String literals
•
Arithmetic expressions
If you use a column identifier as a print item in a BREAK TITLE command, the value
for that item is taken from the first detail line of the break group.
You must enclose the print list of a BREAK TITLE command in parentheses.
Figure 4-8. A Page Title With a Row Value
Customer Delivery Summary
Cust. No. 21
(Page Break)
CUSTNUM
21
123
CUSTNAME
CENTRAL UNIVERSITY
BROWN MEDICAL CO
STATE
PENNSYLVANIA
CALIFORNIA
DELIV_DATE
870720
871101
870820
Customer Delivery Summary
Cust. No. 143
CUSTNUM
143
CUSTNAME
STEVENS SUPPLY
STATE
COLORADO
DELIV_DATE
871020
324 PREMIER INSURANCE TEXAS 870915
543 FRESNO STATE BANK CALIFORNIA 870810
(Page Break)
Customer Delivery Summary
Cust. No. 926
CUSTNUM
926
CUSTNAME
METALL-AG
STATE
WEST GERMANY
DELIV_DATE
880701
1234 DATASPEED NEW YORK 880410
3210 BESTFOODS MARKETS NEBRASKA 881101
(Page Break)
Customer Delivery Summary
Cust. No. 3333
CUSTNUM
CUSTNAME STATE
DELIV_DATE
3333 NATIONAL UTILITIES CANADA 881010
VST0408.vsd