IBM SC41-5210-04 manual Division, Region

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:

vBreak level 1 = company

vBreak level 2 = division

vBreak level 3 = region

vBreak level 4 = department

vBreak 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:

vA blank line to separate the summary information from the column data.

vAny break text defined for that break level, including any break values that are defined in that text.

vAny 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.

vAnother 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.

140Query for iSeries Use V5R2