Filter
Top Products
N=No
Any summary values are not to be suppressed. They are to be included each time that a report break
occurs at this break level.
Y=Yes
All summary values are to be suppressed. They are not to be included for this break level.
Break text in Query for iSeries reports
Type any text that you want to appear at each report break for this break level. The text can be as long as
40 characters. The text appears ahead of any summary lines for this report break.
If you include &XXXXXX (where XXXXXX is any one of the selected fields in your query) in the text, the current
value of the field appears in place of &XXXXXX in the text in the report. For example, if you entered break
text of:
Totals for &CITY &STATE
you might get:
Totals for Glendale CA
If you entered break text of:
&FINIT&MINIT &LNAME
you might get:
JY Clarke
Notice that a blank should follow a field name. An exception is that a second field name can follow a field
name. As shown in the second example, the middle initial field, &MINIT, follows the first initial field, &FINIT,
with no blank between them. The characters /, -, or : may also follow a field name. You can also type
characters directly in front of a field name.
The field names can be uppercase, lowercase, or a mixture: &LNAME, &lname,or&Lname. Blanks at the end
of field values, such as Glendale, are dropped. Blanks in front of field values are also dropped.
Note: Any changed lengths (except 0) specified on the Specify Report Column Formatting display are
used. However, if 0 was specified for a field (to exclude the field from the report in column form),
then the originally defined length and decimal position values are used in the break text.
The inserted value appears as it would in a report column.
v Any editing or formatting specified for numeric fields is applied.
v A null value is shown as a dash (-).
v Replacement characters are used to indicate error conditions.
Query prints only part of the text if the width is not large enough on a printed report. However, field value
substitutions in the break text are either wholly included or excluded. If there is not enough room left to
print all of a value, none of it is printed.
To suppress summaries for break level 0 and prevent the FINAL TOTALS line from appearing in the report,
you must answer Y (Yes) to the Suppress summaries prompt and you must blank out the text in the
prompt for break level 0.
144 Query for iSeries Use V5R2