Upgrade your Internet Experience
Microsoft.com
Welcome Sign in
SQL Server Developer Center
Click to Rate and Give Feedback

  Switch on low bandwidth view
Community Content
In this section
Statistics Annotations (0)
SQL Server 2005 Books Online (November 2008)
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.

ms345322.note(en-US,SQL.90).gifImportant:
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.
Tags What's this?: Add a tag
Community Content   What is Community Content?
Add new content RSS  Annotations
© 2009 Microsoft Corporation. All rights reserved. Terms of Use  |  Trademarks  |  Privacy Statement
Page view tracker