Connecting To Report Data How-to Topics

The first step in creating a report is to define a data source connection and specify a query that retrieves the data you want to use. In Reporting Services, the data source connection and query is part of a dataset. A report must contain at least one dataset, but you can create multiple datasets if you want to use data from a variety of data sources or queries. For more information, see Creating a Data Source, Creating a Report Dataset, and Working with Your Data (Reporting Services).

In This Section

Report Data Pane How Tos

• How to: Dock the Report Data Pane

Report Data Source How Tos

• How to: Create a Report Model Data Source

• How to: Create an Embedded or Shared Data Source

• 'How to: Register a Standard .NET Framework Data Provider

• How to: Verify a Connection to a Data Source

• How to: Convert a Data Source from Embedded to Shared)

Report Dataset How Tos

• How to: Retrieve Data from a SQL Server Data Source

• How to: Retrieve Data from an Analysis Services Cube (MDX)

• How to: Retrieve Data from a Data Mining Model (DMX)

• How to: Retrieve Data from a SAP NetWeaver BI Data Source

• How to: Retrieve Data from a Hyperion Essbase Data Source

• How to: Retrieve Data from an Oracle Data Source

• How to: Add, Edit, or Delete a Field in the Report Data Pane

• How to: Associate a Data Region with a Dataset

• How to: Create a Dataset

• How to: Refresh Fields in the Data Pane

• How to: Open a Query Designer for a Dataset Query

Query Parameter How Tos

• How to: Associate a Query Parameter with a Report Parameter

Multidimensional Data How Tos

• How to: Define Parameters in MDX and DMX Query Designer

• How to: Select a Cube

• How to: Add a Calculated Member for an Analysis Services MDX Query

• How to: Add a Calculated Member for a SAP Netweaver BI MDX Query

• How to: Set a Variable for an SAP Netweaver BI MDX Query

See Also

Concepts

Connecting to Your Data (Reporting Services)

Analysis Services DMX Query Designer User Interface

Analysis Services MDX Query Designer User Interface

SAP Netweaver BI Query Designer User Interface

SMDL Query Designer User Interface

SQL Server Query Designer User Interface

Hyperion Essbase Query Designer User Interface

Text-based Query Designer User Interface

Other Resources

SQL Server Query Designer User Interface

Designing and Creating Reports