SQL/MP Report Writer Guide

Customizing a Report
HP NonStop SQL/MP Report Writer Guide—527213-001
4-20
Labeling Information
S> PAGE TITLE "Customer Delivery Summary ",
+> TAB 45,
+> "Cust. No.",
+> C.CUSTNUM AS I4 ;
S> SET LAYOUT PAGE_LENGTH 10;
S> LIST N 10;
Figure 4-8 shows the first nine rows of report output, which appears on four pages. The
customer number in each page title is taken from the first row of output on the page.
The page length, which is ten lines, accommodates these items:
•
The default top margin (a blank line)
•
A single-line title followed by a blank line
•
Two lines of headings followed by a blank line
•
Three detail lines
•
The default bottom margin (a blank line)
Figure 4-8. Example of 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