Progress
Report Builder
User’s Guide
Sorting Considerations
When you specify the sort order for a report, you must consider:
Field Restrictions
You can sort on any type of field except memo fields.
Best Fields for Sorting
The following fields are best for sorting:
- Database fields.
- Server-evaluatable calculated fields. Report Builder marks these fields with an “e” (for evaluatable) in the field list. See "Calculated Fields," for a description of server-evaluatable fields.
These fields are best for sorting because Progress performs the sort. If you select Report Builder aggregate fields or calculated fields that are not server-evaluatable, Report Builder performs the sorting using local temporary files. Selecting such fields for sorting might cause a significant slow down in report processing, especially for reports involving large amounts of data. It might also require a large amount of local disk space.
Case Sensitivity
Report Builder applies case sensitivity when it sorts character fields according to the case sensitivity of the field.
Sorting on Indexed Fields
To achieve more efficient performance, sort on indexed fields whenever possible.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |