Progress
Report Builder
User’s Guide
Filtering on Calculated Values
Report Builder allows you to select records based on calculated fields values except those that:
You can compare a field to an expression by using a calculated field in a filter. For example, to define a filter that selects all records where the value in the Amount field equals the value of Discount * Rate, create a calculated field named Disc-Rate using this expression:
Then select Disc-Rate as the value in the filter using this expression:
Depending on the complexity of the calculated field expression, Report Builder or the database server might process the filter. See the "Server-evaluatable Filters" section in "Calculated Fields," for more information about expression processing.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |