Show Hidden Datasets for Parameter Values for Multidimensional Data (Report Builder and SSRS)


Applies To: SQL Server 2016

Your report might include automatically-generated datasets (also known as hidden datasets) that do not appear by default in the Report Data pane. These datasets are created in the following ways:

  • In some query designers for multidimensional databases, you can specify fields to filter on in the filter area of the query pane, and select whether to create a query parameter for the filter. If you select the parameter option, report datasets are automatically created to provide valid values for the report parameter.

  • If you import a query based on multidimensional databases, you might also include hidden datasets in your report.

Hidden datasets are not available to use from a wizard.

You can change the view in the Report Data pane to display all datasets in the report.

System_CAPS_ICON_note.jpg Note

You can create and modify paginated report definition (.rdl) files in Report Builder and in Report Designer in SQL Server Data Tools. Each authoring environment provides different ways to create, open, and save reports and related items.

To display hidden datasets

  • In the Report Data pane, right-click the Datasets folder, and then click Show Hidden Datasets.

Query Designers (Report Builder)
Reporting Services Query Designers
Report Embedded Datasets and Shared Datasets (Report Builder and SSRS)
Report Datasets (SSRS)

Community Additions