Lesson 5: Publishing a Report Model Project
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/.
Next Steps
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 https://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 Managing Permissions and Security for 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 start Report Builder, click the Report Builder button in Report Manager. 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.
Change History
| Release | History |
|---|---|
12 December 2006 |
|
See Also
Concepts
Reporting Services Tutorials
Tutorial: Creating a Report Model
Other Resources
Working with Model Designer
Model Designer
Report Builder
Report Model Designer Wizard F1 Help
How to: Start Report Builder
Report Manager
Managing Permissions and Security for Reporting Services
Setting Permissions for Report Server Operations in a SharePoint Web Application
How to: Set Permissions for Report Server Items on a SharePoint Site