SQL/MP Report Writer Guide

Customizing a Report
HP NonStop SQL/MP Report Writer Guide—527213-001
4-15
Organizing Rows Into Break Groups
Figure 4-6 shows the resulting report.
When you use the BREAK ON command, consider these points:
•
You can specify only one BREAK ON command at a time. You can edit the
command by using FC, replace the command by reentering it, delete the command
by entering RESET REPORT BREAK ON, or modify the BREAK ON command by
using RESET REPORT BREAK (
column-list).
•
The BREAK ON command must define the break groups at all levels. Specify the
groups and subgroups from most inclusive to least inclusive.
•
You should include an ORDER BY clause in the associated SELECT command to
sort the break columns.
•
You can specify a break column that is not in the detail line. The break occurs, but
the item is not printed. For example, you might want to print the break column
value in the break title but not in the detail line.
•
If the break column is an item in the detail line, you can use the SUPPRESS option
to ensure that the column value appears only in the first row of the group. If a page
break occurs in the middle of the group, the value appears again in the first row of
the new page. If you specify the NOSUPPRESS option, the column value appears
in each detail line of the group.
Figure 4-6. Example of Break Groups
SREP CUSTNUM ORDERNUM PARTNUM UNIT_PRICE QTY_ORDERED
2402
220 324 500450 212
2002
2001
255
8
12
16
16
48
2500.00
3900.00
1100.00
330.00
1500.00
6301
6500
1234
7777
100210
100250
244
2001
2403
5100
244
5103
3
3
6
10
4
10
15
1095.00
245.00
400.00
3500.00
150.00
620.00
1100.00
3500.00
221
222
5635
926
101220
200300
255
5103
7102
7301
244
10
3
7
8
8
425.00
275.00
400.00
3900.00
3500.00
VST0406.vsd