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:

Discount * Rate 

Then select Disc-Rate as the value in the filter using this expression:

Amount = Disc-Rate() 

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