Progress
Report Builder
User’s Guide
Specifying the Sort Order
You can select up to eight fields for sorting the records in your report. When you select a sort field, data in the specified field determines the order in which Report Builder arranges report records. For example, if you use the Customer table to generate a report listing the addresses of your customers, you might want to sort using the Cust-Num or Name fields. If you select Cust-Num as a sort field, Report Builder sorts the report data numerically by the customer number. If you select the Name field, Report Builder sorts the data alphabetically by the Name field of each record.
Follow these steps to specify a sort order for a report’s records:
- Choose Database
Sort Order or the Sort button. The Sort Order dialog box appears:
![]()
The Sort Order dialog box displays the currently defined sort order levels. In this dialog box there are no sort order levels currently defined.
- Choose New to specify a new sort order. The Sort Level dialog box appears:
![]()
- Select the sort order level you want to define from the Sort Level drop-down list.
- Select the field on which you want to sort this level from the Sort Field drop-down list.
The drop-down list displays the connected databases, the joined tables, and the user-defined fields for the report definition. Choose the database, then the table that contains the field you want. Report Builder lists the fields for the selected table.
- By default order, Report Builder sorts the field data in ascending order. Deactivate the Ascending toggle box if you want Report Builder to sort field data in descending order.
- Choose OK. Report Builder returns you to the Sort Order dialog box and displays the newly defined sort level in the Currently Defined Sorts selection list.
- Specify additional sort levels in the same manner, then choose OK to return to the report layout.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |