Tutorial: Creating Model-Based Reports in Report Designer
New: 5 December 2005
You can create reports based on report models within Report Designer and then use Report Designer's functionality to continue to design your report. By using the Report Model Query Designer, you can create a data source, connect to an existing report model, add the fields that you want to your query, and then modify the report definition using Report Designer.
In this tutorial, you will learn how to build a query based on a report model, and then generate the report.
Important
The sample databases are not installed automatically during setup, but you can install them at any time. For information about installing the samples, see Installing Samples.
Requirements
To use this tutorial, your system must have the following installed:
- Microsoft SQL Server 2005 Reporting Services running in native mode. Support for models is not available in SQL Server Express Editions. For more information, see Features Supported by the Editions of SQL Server 2005.
- Microsoft SQL Server 2005 Business Intelligence Development Studio.
- Microsoft SQL Server 2005 with the Adventure Works sample database.
- Microsoft SQL Server 2005 with the Adventure Works report model sample.
In addition, you must have the following permissions:
- To deploy and publish the report model, you need to be assigned to the Content Manager or Publisher role.
- Permissions to retrieve data from the AdventureWorks database.
Tasks
Lesson 1: Creating a Report Server Project for a Report Model-Based Query
Lesson 2: Creating a Data Source for a Model-Based Report in Report Designer
Lesson 3: Creating a Report Model-Based Query
Lesson 4: Designing the Report
See Also
Other Resources
Working with Report Model Query Designer
Report Model Query Designer F1 Help
Working with Models
Working with Report Designer
Report Model Samples