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

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

   

2. In the Field List, select the created field to show its properties in the Property Grid.

3. Change the Field Type property to an appropriate value.

   

4. To create an expression for the calculated field, click the ellipsis in the Expression section.

   The Expression Editor is then displayed.

5. You can also display this window by right-clicking the calculated field within the Field List and selecting Edit Expression.

   

6. Click Fields to display the field list.

7. Double-click field names to add them to the expression string.

8. Use the toolbar to add operators between field names.

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

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

    

    The calculated field is now set up.

11. Switch to the Preview tab to view the result.