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	SQL Server Query Designer User Interface
Microsoft SQL Server Analysis Services	Analysis Services MDX Query Designer User Interface and Analysis Services DMX Query Designer User Interface
Report Server Model	SMDL Query Designer User Interface
XML	Uses default generic query designer with two panes: command text and result pane.
SAP NetWeaver BI	SAP NetWeaver BI Query Designer User Interface
OLE DB	SQL Server Query Designer User Interface
ODBC	SQL Server Query Designer User Interface
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	New content: Added intro and table to all query designer topics. Added art showing default data tab. Changed content: Removed SQL-specific query designer information from this topic.