Working with 13-Review and Reporting > 13-3 Report Writer > Calculated Fields > Creating calculated fields
Learn more

About expressions

About operators

About functions

Inserting calculated fields in reports

Creating calculated fields

When you add the calculated field, its name displays in the Calculated Fields list. You can then insert the field as you would insert any other field. How?

To create a calculated field:

  1. In either 13-3 Report Writer or 13-5 Form/Report Page Design, on the toolbar, select Edit > Calculated Fields.
  2. In the Calculated Fields window, in the Name text box, enter the name of the calculated field you want to create.

    Note: The Name text box has a 15 character limit. You can use spaces and special characters in addition to letters and numbers.

  3. In the Description text box, enter a brief description of the field.
  4. Select Do Not Total, if the calculated field should not be totalled.
  5. Use the Database Fields, Functions, and Operators to build the calculated field expression.
  6. To save the calculation, click Save.

    Note: The Save button is not available unless all required fields (Name, Description, and Calculated Field Expression) are filled out.

  7. Click Close.