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.
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.
- 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.
Tasks
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 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
Concepts
Other Resources
Working with Model Designer
Managing Permissions and Security for Reporting Services