How to: Add, Edit, or Delete a Field in the Datasets Window (Report Designer)

To add or edit a field in the Datasets window

  1. In Layout view, select a dataset from the box at the top of the Datasets window.

  2. To add a field, right-click anywhere in the list of fields, and then click Add. To edit a field, right-click an existing field, and then click Edit.

  3. Type a name to use for the field.

    Note

    Names must be unique within the dataset.

  4. Click Database field or Calculated field, and then type a value. For a database field, this must be the name of a field returned by the query in the dataset. For a calculated field, this must be an expression. Click Expression to build an expression.

    Note

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

To delete a field from the Datasets window

  1. In Layout view, select a dataset from the box at the top of the Datasets window.

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

See Also

Concepts

Adding a Text Box
Working With Fields in a Report Dataset
Report Designer How-to Topics

Other Resources

Report Designer F1 Help

Help and Information

Getting SQL Server 2005 Assistance