Data View (Report Designer)
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 choose 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 choose the data for your report.
The Data view shows, by default, the first dataset and its associated query designer. If no datasets have been defined, the following default view is displayed.
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 |
|
Microsoft 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 |
|
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)
Help and Information
Getting SQL Server 2005 Assistance
Change History
Release | History |
---|---|
14 April 2006 |
|