Edit Field/Add New Field (Report Designer)
Use the Edit Field dialog box to define a field within a dataset.
Type the name of the field. Field names must be unique within a dataset.
- Database field
Select to indicate that the field is linked to a field returned by the query in the dataset. In the text box below Database field, type the name of the field that is returned by the query.
- Calculated field
Select to indicate that the field is calculated based on an expression. In the text box below Calculated field, type an expression that returns data for the field. Click the expression (fx) button to edit the expression.