How to: Refresh Fields for a Dataset

  • Article

The dataset field collection includes the fields that are specified by the query and the calculated fields that you create. You use the Dataset Properties dialog box to specify the query. In some cases, you may use a query designer to help create a query, and run the query at design time to see example data. By running the query, you create the dataset field collection.

However, you may choose to create the query directly in the Dataset Properties dialog box and not run the query in a query designer. To populate the field collection, use the Refresh Fields button on the Dataset Properties dialog box.

The field collection does not appear in the Report Data pane until the Dataset Properties dialog box closes.

To refresh the fields for a specific dataset

  1. In the Report Data pane, right-click the dataset, and then click Dataset Properties.

    Note

    If the Report Data pane is not visible, on the View menu, click Report Data. If the pane opens as a floating window, you can dock it. For more information, see How to: Dock the Report Data Pane.

  2. In the Query pane, type the query. Alternatively, you can use the Import button to import your query from another .rdl file.

  3. Click Refresh Fields.

  4. Click OK.

    In the Report Data pane, expand the dataset node to view the currently defined field collection.

To refresh the fields for all datasets

  • On the File menu, click Save All.

    - OR -

  • Switch from Design to Preview.

See Also

Tasks

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

How to: Create a Dataset (Reporting Services)

Concepts

Creating a Report Dataset

Query Designers and Data Processing Extensions (Reporting Services)