Querying and Defining Report Data (Reporting Services)
Use SQL Server Reporting Services Report Designer to create reports using data from many types of data sources, including relational databases, multidimensional databases, Web services, and XML documents. Report data can be as simple as data from a document or as complex as multidimensional data from business intelligence warehouses. You can present data from multiple data sources in a single report. After you define a report data source, you can use it for a single report or share it among many reports.
Report models are used to create reports in Report Builder or in the Report Model Query Designer within Report Designer. A report model is a metadata description of the underlying data source and the relationships between the data contained within it. Models can be created from SQL Server 2000 and later databases, Analysis Services 2005 and later databases, and Oracle databases running version 188.8.131.52 or later. To create models, you can use one of the following tools: Model Designer, Report Manager, or Management Studio.
- Defining Report Data Sources
Explains how to define and manage a report data source and provides examples of connecting to different types of data sources.
- Defining Report Datasets
Describes the various data source types and query designers, and provides examples for creating datasets for supported data sources.
- Working with Models
Describes how you can create and modify models.
- Querying and Defining Report Data: How-to Topics (Report Designer)
Follow step-by-step instructions to complete tasks for working with data sources, report datasets, and query designers.
- Designing Report Models: How-to Topics
Follow step-by-step instructions to generate report models and to complete tasks in Model Designer.
- Designing Report Models: Tutorials
Follow AdventureWorks-based tutorials to learn how to create and modify models.
ConceptsDesigning and Implementing Reports (Reporting Services)
Designing and Implementing Ad Hoc Reports
Querying and Defining Report Data: How-to Topics (Report Designer)
Working with Model Designer
Working with Fields in a Report Dataset (Reporting Services)