IBM ISERIES SC41-5210-04 - Manual (Page 152)

Define Report Breaks
Type break level (1-6) for up to 9 field names, press Enter.
(Use as many fields as needed for each break level.)
Break Sort
Level Prty Field
1 1 COMPANY
2 2 DIVISION
3 3 REGION
4 4 DEPARTMENT
5 5 EMPLOYEE
Bottom
F3=Exit F5=Report F10=Process/previous F11=Display text
F12=Cancel F13=Layout F18=Files F23=Long comment
An example of when you might need to define five report break levels, would be if you sequenced a group
of payroll time records by employee within department, within region, within division, and within company.
In this case you would assign the following break levels:
v Break level 1 = company
v Break level 2 = division
v Break level 3 = region
v Break level 4 = department
v Break level 5 = employee
You can use any field shown in the list to define a report break; however, in most cases, you should use
only sort fields for break fields. Generally, the break levels should be in the same order as the sort
priorities assigned to the fields. That is, the highest assignable break level (level 1) should be assigned to
a high sort priority number (where 1 is also the highest), break level 2 should be assigned to some lower
priority number, and the lowest break level used should be assigned to the lower sort priority numbers.
If you specify a field as a break field that is not also a sort field, you may get extra report breaks in your
report because if the field is not part of the sorting step, records that belong in the same group may not be
grouped together and will cause the extra breaks.
Break definitions are ignored for detail output to a database file. Refer to “Building a new output file
definition in Query for iSeries reports” on page 156 for more information on how break definitions and
summary functions are used for summary-only output to a database file.
For summary-only printed or displayed output, a line of break values is shown instead of the detail lines for
the break group. For either detail or summary-only printed or display output, one or more of the following
appears at each report break:
v A blank line to separate the summary information from the column data.
v Any break text defined for that break level, including any break values that are defined in that text.
v Any summaries (totals, averages, minimum and maximum values, and counts) that you specified on the
Select Report Summary Functions display. Columns with no break or summary values to be shown are
omitted.
v Another blank line, or if the report is printed, you can specify for any break level that a new page be
started after the summary information is printed.
140 Query for iSeries Use V5R2