Edit Calculated Fields Dialog of the Report Designer
Calculated fields can be used to create new values that do not exist in the data source. For example, a calculated field can represent a new value, a constant, an expression value, user defined function or even a report parameter, or an existing field that is converted to a different datatype.
Add a Calculated Field
You specify a calculated field manually by creating an expression. The Edit Calculated Fields dialog is available in the property grid of our DataSource components:
by clicking on the ellipsis of the CalculatedFields property.
The dialog accepts Name, DataType and Expression.
Edit a Calculated Field
To edit a Calculated Field, click in the inline editors directly.
Delete a Calculated Field
To delete a Calculated Field, use the Delete Button.
Names must be unique in the datasource and the expression for a calculated field cannot contain aggregates, RowNumber or ColumnNumber global functions.