Share via

Tutorial: Refining a Report Model in Model Designer

New: 5 December 2005

This tutorial is designed to help you fine-tune a report model that was generated using Model Designer. By following this tutorial, you will better understand how these refinements affect the client reporting experience.


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.
  • SQL Server 2005 with the AdventureWorks sample database.
  • SQL Server 2005 Business Intelligence Development Studio.

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.
  • To retrieve data from the AdventureWorks database.


Lesson 1: Creating a Report Model in Model Designer

Lesson 2: Adding a Description to a Model

Lesson 3: Organizing a Model Using a Folder

Lesson 4: Renaming Model Items

Lesson 5: Hiding Model Items

Lesson 6: Specifying the Default Width of a Field

Lesson 7: Specifying the Default Format of a Field

Lesson 8: Specifying Default Detail Attributes

Lesson 9: Specifying a Lookup Entity

Lesson 10: Inheriting Properties from Other Entities

Lesson 11: Creating a Calculated Field

Lesson 12: Specifying Clickthrough Report Options

Lesson 13: Creating a Perspective

See Also


Reporting Services Tutorials

Other Resources

Working with Model Designer
Managing Permissions and Security for Reporting Services

Help and Information

Getting SQL Server 2005 Assistance