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 |