Export (0) Print
Expand All
2 out of 4 rated this helpful - Rate this topic

Tutorial: Creating Model-Based Reports in Report Designer

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.

Important noteImportant

SQL Server samples and sample databases must be downloaded and installed before you can view or work with them. For more information, see Considerations for Installing SQL Server Samples and Sample Databases.

To use this tutorial, your system must have the following installed:

  • Microsoft SQL Server Reporting Services running in native mode. Support for models is not available in SQL Server Express.

  • Microsoft SQL Server Business Intelligence Development Studio.

  • Microsoft SQL Server with the Adventure Works sample database.

  • Microsoft SQL Server 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 AdventureWorks2008R2 database.

Did you find this helpful?
(1500 characters remaining)
Thank you for your feedback

Community Additions

ADD
Show:
© 2014 Microsoft. All rights reserved.