SQL/MX Report Writer Guide

Customizing a Report
HP NonStop SQL/MX Report Writer Guide—527194-002
4-27
Line Numbers
+> PARTNUM HEADING 'Part No.',
+> QTY_ORDERED HEADING 'Quantity';
S> BREAK ON C.CUSTNUM, CUSTNAME, R.ORDERNUM;
S> BREAK FOOTING C.CUSTNUM
+> ('Earliest Delivery Date: ',
+> DELIV_DATE AS I6,
+> SKIP 1) ;
S> BREAK FOOTING R.ORDERNUM
+> ('Order', R.ORDERNUM,
+> SPACE 3,
+> 'Salesperson's number: ',
+> SALESREP,
+> SKIP 1) ;
S> LIST NEXT 10;
Figure 4-12 shows the report. The DELIV_DATE value in the first footing is taken from
the last row of each customer break group. The ORDERNUM value is taken from the
last row of each order break group.
Line Numbers
The report writer provides a LINE_NUMBER function for numbering the lines of a
report. You can use one sequence for the whole report or restart the numbering at a
new page or at a new break group.
Figure 4-12. Break Footings
Order 200320 Salesperson's number : 223
Earliest Delivery Date : 870720
Order 200490 Salesperson's number : 226
Earliest Delivery Date : 870820
Order 300380 Salesperson's number : 226
STEVENS SUPPLY 255 4
226
3210
5505
12
6
8
BROWN MEDICAL CO 3210
5505
1
1
CENTRAL UNIVERSITY
5504
6201
6301
6400
5
16
6
7
Part No. Quantity
VST0412.vsd