Data View (Report Designer)

  • Article

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.

Default data pane with no datasets

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.