IBM SC41-5210-04 manual Field

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:

vFor 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.)

vFor numeric fields, the actual data in the fields is used for determining report breaks, not the edited form of the data.

vFor date, time, and timestamp fields, chronological equivalency determines report breaks.

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

vIf 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

142Query for iSeries Use V5R2