Lesson 5: Publishing a Report Model Project

SQL Server 2008 R2

In order to build reports using the model that you just created, you must publish it to a report server or a SharePoint library. The data source and data source view are included with the model when it is published. In this tutorial, you will publish the ModelTutorial model to the report server.

To publish a report model to a report server

  • In Solution Explorer, right-click the ModelTutorial project and then click Deploy.

    The model is saved to the report server using the Target Server URL that you specified when setting up Business Intelligence Development Studio. If any errors or warnings are encountered, they are displayed in the Output window.

    Important   To deploy a report model to a SharePoint library, you must use a fully qualified URL to the library or library folder; for example, http://TestServer/TestSite/Shared Documents/.

Business Intelligence Development Studio defaults to the report server URL automatically. However, if you want to change or view the report server information, you can right-click the ModelTutorial project name and view the properties. The report server URL is specified in the Target Server URL area. By default, the value is http://localhost/reportserver.

To verify that the published model project uploaded successfully to the report server, you can use Report Manager to view items on the server. When publishing a model project, the model is published to the Models folder and its corresponding data source is published to the Data Sources folder.

To use the published model as a basis for a Report Builder report, you must have access to the model. For more information about creating role assignments that provide model access, see Securing Models. If you are running a report server in SharePoint integrated mode, see Granting Permissions on Report Server Items on a SharePoint Site.

Once the model is published, and you have configured role assignments for the users who want to use the model, you can run Report Builder to create a report. To launch Report Builder, click the Report Builder button on the Report Manager toolbar. To create a report in Report Builder, first select a model, referred to as a data source in Report Builder, and a template for the report layout you want (for example, a table). You can then drag and drop the report items from the model to the report.

To learn how you can create a report using this report model, see the "Tutorial: Creating a Table Report" topic in the separate Report Builder Help file that is downloaded to your client computer when you launch Report Builder.

Community Additions

ADD
Show: