This document demonstrates how to add a calculated field to a report. The main purpose of calculated fields is to perform pre-calculations (of virtually any level of complexity) over data fields.
To learn how to easily perform simple calculations within a single data field, see Add Totals to a Report.
In the Report Designer, a calculated field is similar to an ordinary data field e.g. Bind controls to it, group, sort and filter your report against it.
To add a calculated field to your report, follow the instructions below:
1. To Create a Calculated Field in the Field List, Right-Click any Data Member and on the Invoked Menu Choose Add Calculated Field.
2. In the Field List Select the Created Field to Show its Properties in the Property Grid. Among these Options Make Sure to Change the Field Type Property to an Appropriate Value.
3. Create an Expression for the Calculated Field – Click the Ellipsis Button in the Expression Section to Invoke the Expression Editor or Invoke this Dialog by Right-Clicking the Calculated Field within the Field List and Selecting Edit Expression.
Click Fields to see 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 dialog and save the expression, click OK.
4. Drag the Calculated Field from the Field List onto the Required Band.
The report with a calculated field is now ready. Switch to the Preview Tab and view the result.