Progress
Results User’s Guide
for UNIX
Changing the Order of Records in a Report
This section describes how to change the order of records in your report. You can order records by as many as five fields.
- Select the Order option.
A window appears that lists all of the fields in the active files. You can use any of these fields to change the order of the records in the report.
Also, you can order records by more than one field. For example, you can put the records in order by state, and by customer number within each state.
- Select the first field you want to use to order the records.
As you select the fields for the report, Results numbers them in the order you select them. If you select a field by mistake, highlight it again and press RETURN to deselect it. You can also type a number next to the field, and the other selected fields will renumber automatically.
- Continue to select the fields in the sequence you want to order the records.
- Press GO when you are done.
A window appears that lets you choose the order (ascending or descending) for each order field:
![]()
- Enter the type of order you want for each field.
For example, if you put character fields in descending order, they appear in the report in reverse-alphabetical order.
- Press GO or RETURN to apply these changes.
The order definition appears in the Report Info window. For example, this figure shows a sample order definition.
![]()
This order definition tells you that the lines in the report are in order first by sales region, then by customer number within each region. (In each case, the field name is prefixed by the name of the file and the database that contains it.)
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |