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.