Progress
Results User’s Guide
for UNIX
Defining Array Fields for Reports
There is a special type of field you can define in your reports, called an array field. An array field contains several elements of information within one field. Each element shares the same field name and characteristics (length, type, etc.). In Results, array fields are followed by brackets ([ ]). In this example, the Mnth-Quota[ ] field is an array field. This field contains the sales information for each month in a year (months 1-12).
If you select an array for your report, Results can display the information in a stacked vertical format or spread out horizontal format.
For example, if you select the Mnth-Quota[ ] field from the Salesrep file, this window appears:
![]()
The window indicates how you can stack your information or spread it out. If the array contains text, you probably want to leave this line blank and press RETURN. This lets Results display the information under the column header as a paragraph in your report.
However, the Mnth-Quota[ ] field contains information you want to display spread out. Enter the number of each month you want on your report, separated with commas. For example, if you want the monthly sales information for January through June, you would enter 1 through 6 with commas, as shown in this figure.
![]()
This lets Results display those months next to each other in separate columns
(for example Mnth-Quota[1], Mnth-Quota[2], Mnth-Quota[3], etc.). However, you might want to change the labels of the columns to give them more meaning. For example, you might want to change the label for Mnth-Quota[1] to January. To do this, select the Formats and Labels option under the Settings option. See the "Hiding Repeating Values and Changing Field Formats and Labels" section in "A Tour Through Results" for more information on changing column labels.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |