Export (0) Print
Expand All
Expand Minimize

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

  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.

    ms156295.note(en-US,SQL.90).gifNote:
    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.

    ms156295.note(en-US,SQL.90).gifNote:
    The expression for a calculated field cannot contain aggregates or references to report items.

  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.

Community Additions

ADD
Show:
© 2014 Microsoft