Filter
Top Products
When you specify the above parameters and press the Enter key, the Define Text
Detail display (or the Define Box Detail display) appears again.
When you specify multiple summary data on the
Text data
prompt, the Select
Fields to Define Summary Data display appears. You can select fields to change
the summary function or specify an edit code on the display.
The Define Summary Data display appears repeatedly for each selected field.
If you specify break fields, you can print the summary data for each page break or
for each page by specifying Y or N for the
Print at page break only
prompt on the
Define Text Detail display (or the Define Box Detail display). The
Print at page
break only
prompt appears at the bottom of the Detail display, and it appears only
when you specify break fields. For example, if you want to print the total of the
SALES field for each page, specify the prompts as follows:
Field Name Description
Field Shows the field name for which the summary function is being used.
Summary
function
Shows the special value used to summarize the field values. The
following summary function special values can be specified to print the
summary data.
*FIRST The first value in the specified field.
*LAST The last value in the specified field.
*TOTAL The total of the values in the specified field. This summary
data is effective for numeric fields, excluding floating-point
data. The number of integer digits of the total is the number
of integer digits of the field plus three. For example, the
total of the field whose integer digits are three and the
fractional digits are two is printed as numeric data with six
integer digits and two fractional digits.
*AVG The average of the value in the specified field. This
summary data is effective for numeric fields, excluding
floating-point data.
*MAX The maximum value in the specified field.
*MIN The minimum value in the specified field.
*CNT The record count. It is printed as 8 digit integer. If there is
a record whose field value is null, the record is not counted.
Edit code Specifies the edit code in which the summary data is printed. The
allowable edit codes (1-9, A-D, J-Q, X-Z) and their printout format are
the same as those supported on DDS. If this parameter is not
specified, the Print Format Utility prints the field based on the editing
information defined by DDS or IDDU except for the record count. The
Print Format Utility prints the record count with the leading zeros
| suppressed by blanks if an edit code is not specified.
Edit code
modifier
This parameter is optional. It is effective only when one of 1-4, A-D,
and J-Q is specified on the edit code parameter.
1 An asterisk (*) is printed for each zero that is suppressed. A
complete field of asterisks is printed for a zero balance field.
2 The currency symbol defined on the system value QCURSYM is
printed on the left of the first significant digit. The symbol is not
printed on a zero balance when an edit code is used that
suppresses the zero balance.
Chapter 10. Work with PFD Definitions 177