IBM SC41-5210-04 manual Skip to new page in Query for iSeries reports

Defining report break formatting in Query for iSeries reports

The Format Report Break display is used to format each of the break levels (1 through 6) that you defined on the Define Report Break display. This display is shown once for each of the break levels that you defined for your query. You can also specify some formatting characteristics for break level 0, which is the ‘Final Totals’ break level provided by Query. You can think of break level 0 as the group that includes all of the selected records. Formatting information on this display affects only output to printer and output to display.

For all break levels except break level 0, you can specify whether the report is to skip to a new page after a particular report break occurs. For each break level (1 through 6), you can also specify whether the summary function values are to be suppressed. You can also specify the break text (if any) that you want included with (or instead of) any summary information. The break text appears after the column data, on the line before any summary values.

	Format Report Break
Break level	: 1

Type choices, press Enter.

(Put	&field in text to have break values inserted.)
Skip to new page		N	Y=Yes, N=No
Suppress summaries . . . .		N	Y=Yes, N=No
Break text		Company
Level	Field	Level	Field
1	COMPANY	4	DEPARTMENT
2	DIVISION	5	EMPLOYEE

3REGION

F3=Exit	F5=Report	F10=Process/previous	F12=Cancel
F13=Layout	F18=Files	F23=Long comment

Skip to new page in Query for iSeries reports

Type a Y or N to specify, for this break level, whether printing is to start on a new page after a report break occurs for this break level. The summary information or break text, if any, for this break level is printed before skipping to the next page occurs.

This prompt applies to printed reports only and is ignored for displayed reports. For break level 0, this prompt is not shown.

Y=Yes

Query is to skip to a new page after any summary values are printed on the current page for each report break that occurs for this break level.

N=No

Query is not to skip to a new page when a report break occurs for this break level. Instead, it is to skip the number of lines you specify on the Define Printer Output display plus one additional line (see Chapter 13, “Selecting output type and output form in Query for iSeries reports”).

Suppress summaries in Query for iSeries reports

Type a Y or N to specify, for this break level, whether summary values (if any summary functions were selected) are to be suppressed. You may want to exclude summary values for level 0 (Final Totals) if they are not needed.

Chapter 12. Defining Query for iSeries report breaks 143