How to: Add, Edit, or Delete a Field in the Report Data Pane

A dataset field collection consists of query fields specified by the dataset query and calculated fields that you specify manually. After you create a dataset, expand the dataset node in the Report Data pane to view the field collection. Whenever you change the query in a query designer, the list of query fields is created again. The fields that you specify manually are not changed.

Add a calculated field when you want to create field that does not exist on the data source, for example, a field combining first and last name in a custom format, or calculating discounts on existing sales and sales date fields.

To add a query field

  1. In the Report Data pane, right-click the dataset, and then click Add Query Field.

    Note

    If you cannot see the Report Data pane, from the View menu, click Report Data.

  2. In the Fields page of the Dataset Properties dialog box, click Add, and then click Query Field. A new row is added to the bottom of the grid.

  3. In the Field Name text box, type the name for the field.

    Note

    Names must be unique in the dataset.

  4. In the Field Source text box, type the name of an existing field on the data source.

  5. Click OK.

To add a calculated field

  1. In the Report Data pane, right-click the dataset, and then click Add Calculated Field.

  2. In the Fields page of the Dataset Properties dialog box, click Add, and then click Calculated Field. A new row is added to the bottom of the grid.

  3. In the Field Name text bo, type the name for the field.

    Note

    Names must be unique in the dataset.

  4. In the Field Source text box, type the expression for the field. Click the expression (fx) button to build an expression.

    Note

    The expression for a calculated field cannot contain aggregates or references to report items.

  5. Click OK.

To edit a query field or a dataset field

  1. In the Report Data pane, right-click the field, and then click Field Properties.

  2. In the Fields page of the Dataset Properties dialog box, click an existing field to select the row.

  3. Change the name of the field or the value of the field.

  4. Click OK.

To delete a query field or a calculated field

  1. In the Report Data pane, expand the dataset to display the field collection.

  2. Right-click the field you want to remove, and then click Delete.