Progress
Report Builder
User’s Guide
Server-evaluatable Fields
Server-evaluatable fields are calculated fields you can use in a sort, join, or filter that the database server, rather than Report Builder, evaluates. Report Builder indicates that a calculated field is server evaluatable by displaying an “e” before the field’s expression in the status bar and in the Field Properties box.
A field is server evaluatable if it meets all four of these criteria:
- The field expression does not use any other operators except those that are listed below:
- Arithmetic operators — addition (+), subtraction (-), multiplication (*), division (/)
- Boolean operators — AND, OR, NOT
- Relational operators — equal to (= or EQ), not equal to (<> or NE), less than (< or LT), less than or equal to (<= or LE), greater than (> or GT), greater than or equal to (>= or GE)
- The field expression uses only the following functions:
ABSOLUTEASCCAPSCHRDATEDAYENCODEENTRYEXPFILL LCLEFT-TRIMLENGTHLOGMONTHNUM-ENTRIESOPSYSR-INDEXREPLACE RIGHT-TRIMROUNDSQRTSUBSTRINGTIMETODAYTRIMWEEKDAYYEAR- The expression’s case sensitivity matches the case sensitivity that you specified for it in the New Calculation or Edit Calculation dialog box. Report Builder determines the expression’s case sensitivity according to the rules described in the "Case Sensitivity" section of this chapter.
- The field does not reference any aggregate fields or any other calculated fields unless they are server-evaluatable also.
You can select a server-evaluatable calculated field as the controlling table join field when defining a table join. Also, filtering and sorting on server-evaluatable calculated fields is much more efficient than filtering and sorting on calculated fields with expressions that Report Builder evaluates itself.
Copyright © 2004 Progress Software Corporation www.progress.com Voice: (781) 280-4000 Fax: (781) 280-4095 |