Progress
Report Builder
User’s Guide


Editing a Calculated Field

You can edit a calculated field’s name and expression. Follow these steps to edit a calculated field:

  1. Choose Calculations Calculated Field. The Calculated Fields dialog box appears:
  2. Select the calculated field you want to modify.
  3. Choose the Edit button. The Edit Calculation dialog box appears. You edit the expression the same way you originally created it:
  4. Modify the field expression as necessary. If the calculated field’s data type changes as a result of editing and the field is used in another calculated field expression, Report Builder displays a list of calculated fields that will be affected by your change. The fields on this list will either change their data types or become impossible for the Report Builder to evaluate as a result of your change.
  5. You can choose Cancel to cancel the change or OK to make the change. If you choose OK, Report Builder flags the fields it cannot evaluate with question marks, in the Field Menu. If you use the flagged fields in your report, you will have to edit their expressions before you can print or view the report.

    NOTE: You cannot change the data type of a calculated field that is used as a join field, appears in a filter, or is totaled.

  6. Choose OK to make the selected changes to the expression and return to the Calculated Fields dialog box.
  7. Choose OK to return to the report layout.

Because Report Builder determines the format and width of a calculated field when you first created it, and because editing a calculation does not automatically change this estimated width, you might have to adjust the format and width of your calculated fields using
Properties Format. For instructions on changing field width and format, see Fields."


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