IBM SC41-5210-04 manual Break text in Query for iSeries reports

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.

vAny editing or formatting specified for numeric fields is applied.

vA null value is shown as a dash (-).

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

144Query for iSeries Use V5R2