Format the Report

The next three fields — Report Title, Fields & Overrides, and No of Ref Fields — control the format of the report. If you wish to include embedded spaces in your report title, enter hyphens (-) in the appropriate place. A report title has a maximum length of 50 characters.

You control which fields are printed and in what sequence using the Fields & Overrides parameter. In this parameter you supply the field name(s) to be selected from the View for printing. The default is to print all fields. Use double quotes to enclose field names that contain embedded blanks.


Field names may be selected with wildcards by placing an asterisk (*) after the significant characters of the field name. All fields beginning with the significant characters (generic portion of the field name) will be printed. An asterisk (*) by itself will select all fields.

Print all fields beginning with D.

Example: FIELDS=D*

Print all fields and repeat the two keys again.

Example: FIELDS=*,KEY1,KEY2

The first occurrence of a generic field name may be printed by using an exclamation mark (!) after the significant character(s). To select a number of occurrences repeat the significant character(s) and the exclamation character a number of times.

Print the first two fields beginning with D.

Example: FIELDS=D!,D!

All fields in a View with ATTRIBUTE=SUPPRESS may be printed only by being explicitly named or by generic selection.

In order to identify the fields that overflow onto a second or subsequent page, the No of Ref Fields is used to specify the number of fields to be reprinted on the left side of the second page containing the overflow field columns that do not fit on page one. The default is zero, indicating that no fields are to be repeated.