Progress
Report Builder
User’s Guide


Filtering on Aggregates

When you filter on an aggregate field (or on a calculated field whose expression includes an aggregate field), Report Builder does not include records that do not satisfy the conditions established by the filter in the aggregate. For this reason, aggregate field filters might not select the records you expect unless you designate the aggregate fields as prepass. For example, to print only those orders with amounts over $1,000, make the invoice aggregate prepass and define a filter condition that selects all records in which the value of the aggregate field is greater than 1,000.

Because of the way the Report Builder processes aggregates, you cannot filter on:

See "Filters," for more information about filtering on aggregate fields.


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