Export (0) Print
Expand All
Expand Minimize

How to: Show Hidden Datasets (Report Builder 2.0)

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 enable a view in the Report Data pane to display all datasets in the report.

To display hidden datasets

  • In Design view, right-click an empty area of the Report Data pane, and then click Show Hidden Datasets.

Was this page helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft