Tutorial: Creating Model-Based Reports in Report Designer

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.


SQL Server samples and sample databases must be downloaded and installed before you can view or work with them. For more information, see Considerations for Installing SQL Server Samples and Sample Databases.


To use this tutorial, your system must have the following installed:

  • Microsoft SQL Server Reporting Services running in native mode. Support for models is not available in SQL Server Express.

  • Microsoft SQL Server Business Intelligence Development Studio.

  • Microsoft SQL Server with the Adventure Works sample database.

  • Microsoft SQL Server 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 AdventureWorks2008R2 database.