Report Data How-to Topics (Report Designer)

New: 5 December 2005

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. This section provides step-by-step instructions for adding data to a report.

In This Section

How to: Add a Calculated Member for an Analysis Services MDX Query (Report Designer)

How to: Add a Data-Bound Image (Image Wizard)

How to: Add a Filter (Report Designer)

How to: Add a Filter in MDX Query Designer for Analysis Services (Report Designer)

How to: Add a Subreport and Parameters (Report Designer)

How to: Add, Edit, or Delete a Field in the Datasets Window (Report Designer)

How to: Add, Edit, or Delete a Report Parameter (Report Designer)

How to: Associate a Data Region with a Dataset (Report Designer)

How to: Associate a Query Parameter with a Report Parameter (Report Designer)

How to: Create a Dataset (Report Designer)

How to: Create or Edit a Report-Specific Data Source (Report Designer)

How to: Create or Edit a Shared Data Source (Report Designer)

How to: Create a Report Model Data Source (Report Designer)

How to: Define Parameters in MDX and DMX Query Designer for Analysis Services (Report Designer)

How to: Select a Cube (Report Designer)

See Also

Concepts

Report Designer How-to Topics
Working with Data in a Report Layout

Other Resources

Designing and Creating Reports

Help and Information

Getting SQL Server 2005 Assistance