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.

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.

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.

Community Additions