Progress
Results User’s Guide
for Windows
Specifying the Sort Order
Follow these steps to change the order in which Results sorts records:
- Choose Data
Sort Ordering. The Sort Order Fields dialog box appears.
Notice that the Available Fields selection list contains all the fields in the query. You can use any field to sort records, including some calculated fields and fields that are not displayed in the query view. The available calculated fields appear at the top of the Available Fields list:
![]()
- You can use up to 16 fields to sort the records in the query. To choose the sort fields, select the fields from the Available Fields selection list, then choose Add.
The fields appear in the Selected Fields selection list. Note that the fields appear in the order in which Results uses them to sort the records:
![]()
- If you selected only one sort field or you are satisfied with the order of the sort fields, go to step 4. Otherwise, to change the order of the sort fields, select one field at a time and choose either the Move Up or Move Down button.
- By default, the fields are sorted in ascending order. To sort a field in descending order, select the field, then choose the Descending radio button:
![]()
- When you are done setting the sort criteria, choose OK to update the sort order and redisplay the query.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |