Progress
Report Builder
User’s Guide


Sorting on Aggregates

You can sort on any aggregate field for which you specified prepass processing. For example, to produce a report listing products in order of the total number of orders, you first create a prepass order count field. Then, you choose the Sort icon to specify the order total field as the first sort field.

You can also sort on calculated fields whose expressions include prepass aggregates, unless the expressions also include table fields. For example, you can sort on a calculated field whose expression uses a prepass customer total field and a prepass order total field (for example, Order-Total/Cust-Total). However, because of the way the Report Builder processes aggregates, you cannot sort on a calculated field that figures a percent-of-aggregate by dividing a table field by a prepassed aggregate (for example, Price/Order-Total).

See "Sorting and Grouping Data," for more information on sorting pre-passed aggregates.


Copyright © 2004 Progress Software Corporation
www.progress.com
Voice: (781) 280-4000
Fax: (781) 280-4095