SQL/MX Report Writer Guide

Customizing a Report
HP NonStop SQL/MX Report Writer Guide—527194-002
4-29
Line Numbers
If you change the previous DETAIL command to specify LINE_NUMBER OVER
PARTNUM AS I4, the line number is reset at the beginning of each break group as
shown in Figure 4-14.
Figure 4-13. Numbering Lines
Parts Supplier List
Page 1
Part 212
Part 244
Part 255
1
2
Part Cost
Supplier
Part Cost
Supplier
Part Cost
Supplier
Part Cost
Supplier
3
4
5
Part Cost
Supplier
2000.00
1900.00
2400.00
2200.00
3300.00
1 NEW COMPUTERS INC
3 HIGH DENSITY INC
1 NEW COMPUTERS INC
1 DATA TERMINAL INC
1 NEW COMPUTERS INC
VST0413.vsd