IBM ISERIES SC41-5210-04 - Manual (Page 154)

You can exclude break fields from showing in the report in column format and still use their values in the
report’s break text. That is, if you specify a 0 in the Len column of the Specify Report Column Formatting
display for a field, no column of data for the field appears in the report. But you can still specify that the
field be used as a break field so that its value, when a report break occurs, is included in the break text
defined for that level of report break.
The following are additional considerations regarding the occurrence of report breaks:
v For SBCS data in SBCS, DBCS-open, and DBCS-either character fields, a report break may not occur
even though the characters in a field may be different. For example, if the collating sequence treats
each uppercase and lowercase letter as having the same value (
Aa, Bb, Cc, and so on), then no report
break occurs if the only change in a field is from A to a, for example. (Collating sequences are not used
for DBCS character data in DBCS fields.)
v For numeric fields, the actual data in the fields is used for determining report breaks, not the edited form
of the data.
v For date, time, and timestamp fields, chronological equivalency determines report breaks.
v For both character and numeric fields, the original definition size of each field is used for determining
report breaks, not any changed size that may have been specified on the Specify Report Column
Formatting display.
v If null values are found, they are grouped together.
The following are sample report breaks showing null values:
Table 5. Sample File Data
Field 1
Field 2
1 AZ
1 AZ
2 XY
2 null value
3 null value
null value AB
If sort and report breaks are specified on Field 1 and MIN and MAX are specified on Field 2, the following
summary only report is shown:
Table 6. Summary Only Report with Null Values
Field 1 Field 2
1
MIN AZ
MAX AZ
2
MIN XY
MAX XY
3
MIN –
MAX –
MIN AB
MAX AB
FINAL TOTALS
MIN
AB
MAX XY
142 Query for iSeries Use V5R2