Add Calculated Fields to a Report

The main purpose of calculated fields is to perform calculations using data in multiple data fields. To learn how to perform calculations within a single data field, refer to Add Totals to a Report or Group.

To add a calculated field to a report, follow the instructions below:

• To create a calculated field, right-click any item in the Field List and choose Add Calculated Field from the displayed menu.

  

• In the Field List, select the created field to show its properties in the Property Grid. Change the Field Type property to an appropriate value.

  

• To create an expression for the calculated field, click the ellipsis in the Expression section. The Expression Editor is then displayed. The user can also display this window by right-clicking the calculated field within the Field List and selecting Edit Expression.

  

  Click Fields to display the field list. Double-click field names to add them to the expression string. Use the toolbar to add operators between field names.

  To close the window and save the expression, click OK.

• Drag the calculated field from the Field List onto a control or a table cell.

  

The calculated field is now set up. Switch to the Preview tab to view the result.