Data View (Report Designer)
[This topic is pre-release documentation and is subject to change in future releases. Blank topics are included as placeholders.]
The Data view in Report Designer is a query designer used for building datasets that retrieve metadata about a data source, which you use to design your report layout. When you create a new dataset, you select the type of data source to use. Each dataset can only have one data source. Each data source is associated with one or two query designers that help you explore the underlying data on the data source and select the data for your report.
By default, the Data view shows the first dataset and its associated query designer. If no datasets have been defined, the following default view is displayed.
.gif)
The following table lists data source types and the associated query designer topics that define the panes, toolbars, and buttons for each query designer.
| Data source type | Query designer UI topic |
|---|---|
Microsoft SQL Server |
|
SQL Server Analysis Services |
Analysis Services MDX Query Designer User Interface and Analysis Services DMX Query Designer User Interface |
Report Server Model |
|
XML |
Uses default generic query designer with two panes: command text and result pane. |
SAP NetWeaver BI |
|
Hyperion Essbase |
|
OLE DB |
|
ODBC |
|
Any registered .NET data provider |
Uses default generic query designer with two panes: command text and result pane. |
See Also
Other Resources
Defining Report Datasets
How to: Associate a Data Region with a Dataset (Report Designer)
How to: Create a Dataset (Report Designer)