Creating a Calculated Field

Calculated fields are data fields that can be created to perform calculations over different data fields in your report.

To create a calculated field

1.	In My Reports, select the report, then click Edit report.

2.	To edit the existing layout, click the Layout button, then click the Edit this layout in the layout designer button.

For more information, see Changing the Layout.

3.	Click the Fields List tab.

4.	To add a new calculated field to the field list, in DataSet1, right-click the Table folder and click Add Calculated Field.

The new calculated field is created under the Table folder.

5.	To open the Collection Editor, right-click the new calculated field, and click Edit Calculated Field.

6.	Enter a name in the (Name) property.

7.	In the calculated field properties, select the appropriate field type.

Possible field types include String, DateTime, TimeSpan, Byte, Int16, Int32, Float, Double, Decimal and Boolean.

8.	To open the Expression Editor, click Expression property and click .

9.	Set the applicable expression and click OK.

The calculated field value is based on the results of the expression. The expression can be created using functions, operators, data fields, constants and parameters. For example, to create a full name field from two fields (First and Last Name) use “”.

For more information, see the Report Designer User Guide (Developer Express), located in the folder where you installed the Report Manager.

10.	Click OK to save the calculated field.

11.	Drag and bind the calculated field to any control for display in report layout.

For more information, see Binding a Data Field to a Control.