Calculated Fields
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 based on a specific expression.
In the Report Designer, a calculated field is similar to an ordinary data field (e.g., you can bind controls to it, and group, sort and filter your report against it).
To add a calculated field to your report, follow the instructions below.
-
To create a calculated field, in the Field List, right-click any item inside the data source, and in the invoked menu, select Add Calculated Field.
-
In the Field List, select the created field and switch to the Properties Panel. Make sure to change the Field Type property to an appropriate value.
-
Then, create an expression for the calculated field.
Click the ellipsis button for the Expression property to invoke the Expression Editor. You can also invoke this dialog by right-clicking the calculated field within the Field List and selecting Edit Expression…
Click Fields to see the field list. To add a data field or report parameter to this expression, double-click the required name. A data field is inserted into the expression’s text using its name in [square brackets], and parameters are inserted using the “Parameters.” prefix before their names. Use the toolbar to add operators between field names.
To close the dialog and save the expression, click OK.
-
Finally, drag the calculated field from the Field List onto the required band like an ordinary data field.
The report with a calculated field is now ready. Switch to the Print Preview tab and view the result.
