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:

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