IBM ISERIES SC41-5210-04, User Manual

Page: 155 / 294

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
3 REGION
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