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.

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

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

Hyperion Essbase

Hyperion Essbase 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.

Show: