Progress
Report Builder
User’s Guide
Sort-group Techniques
You can use various sort-group techniques to further control the order of report records. For example, you can:
- Sort and group on aggregate fields as long as you specify that the fields are prepass.
As a general rule, when you select a prepass aggregate field (or calculated field using a pre-pass aggregate) as sort level n, Report Builder inserts an implicit sort level between sort level n and n+1. The implicit sort field is the group field on which the aggregate resets. If your sort level list includes several contiguous prepass aggregates that reset on the same group field, Report Builder inserts the implicit sort level once, after the last of the contiguous aggregates.
- Sort and group on calculated fields as long as they:
- Do not use the PAGE-NUMBER, RECORD-NUMBER, or PREVIOUS functions
- Are not self-referencing
- Are not related to final pass aggregate fields
You can also group on calculated fields whose expressions include both a prepassed aggregate field and a database field. However, you cannot select such fields as sort fields. This restriction is a result of the type of processing that produces prepass aggregates. See "Aggregate Fields," for more information about prepassing aggregate fields.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |