Report Model Generator

For more advanced reporting needs, you can use Report Model Generator to create report models. You can then use these report models with tools such as Microsoft SQL Server Report Builder to create custom reports.

With Report Model Generator, you create the report models based on query views established in the program. Once you select the type of query to use, you can select which fields to include in the model. The model is accessible from the Report Explorer, as well as directly from the Reporting Services server. For more information, refer to Create Report Models.

Note: We recommend you refer to Microsoft’s SQL Server 2008 Books Online in the MSDN library at msdn.microsoft.com for information about how to use Report Builder.

Once you have created a report based on a report model, from the Report Explorer, you can add a shortcut to the report to a page in the program so you can run it from a specific area.