Dataset Properties Dialog Box, Fields (Report Builder)

Select Fields on the Dataset Properties dialog box to change the field collection for the report dataset. The fields list is automatically populated, but you can use Fields to add, edit, and delete query and calculated fields.

Calculated fields are supported only on embedded datasets. For more information, see Report Embedded Datasets and Shared Datasets (Report Builder and SSRS).

Options

  • Add
    Add a new query or calculated field to the dataset.

  • Delete
    Delete the selected field from the dataset.

  • Field Name
    Type a name for the field. The field must be unique within the dataset. For each existing field in the dataset, the name is pre-populated.

  • Field Source
    Enter a value for the field.

    For a calculated field, the field source must be the name of an existing field retrieved by the dataset query, or an expression that you create. For example, to create a field that represents 10 times the value in the query field Sales, use the expression =10 * Fields!Sales.Value.

    For a query field, the field source must be the name of an existing field retrieved by the dataset query.

  • Expression (fx)
    Add or change an expression for the new calculated field. This button only appears when you click Add and select Calculated Field.

See Also

Tasks

Create a Shared Dataset or Embedded Dataset (Report Builder and SSRS)

Reference

Dataset Properties Dialog Box, Options (Report Builder)

Dataset Properties Dialog Box, Filters (Report Builder)

Dataset Properties Dialog Box, Parameters (Report Builder)

Dataset Properties Dialog Box, Query (Report Builder)

Concepts

Dataset Fields Collection (Report Builder and SSRS)

Report Builder Help for Dialog Boxes, Panes, and Wizards

Expressions (Report Builder and SSRS)

Data Connections, Data Sources, and Connection Strings in Report Builder