Report Builder Deploying Reports
By: Ray Barley
When you finish developing a report, you need to deploy it in order to make it available to the appropriate people. This section will provide an overview of the options for deployment in Report Builder 3.0.
There are two options for deploying the reports that you create with Report Builder 3.0:
- Report Manager
- SharePoint document library
The deployment options that are available to you depend on how SQL Server Reporting Services (SSRS) 2008 R2 is setup and configured. Reports that you develop with Report Builder 3.0 can only be deployed to SSRS 2008 R2. An instance of SSRS can be configured in native mode or SharePoint Integrated mode. With native mode you deploy reports to the Report Manager web application. With SharePoint Integrated mode you deploy your reports to a SharePoint document library. In either case you can save your report in Report Builder and specify the appropriate URL for your deployment target.
While an instance of SSRS can be configured for either native mode or SharePoint Integrated mode, you can have multiple instances of SSRS which would allow you to have both options available. From the standpoint of a business user, SharePoint Integrated mode is a good choice; reports are handled just like any document.
To deploy a report, click the diskette icon at the top of the Report Builder window or select Save/Save As from the Report Builder menu; the familiar Save dialog is displayed:
The following are the main points about deploying a report:
- You can save your report to a number of different locations; choose Recent Sites and Servers to navigate to the URL for Report Manager or your SharePoint document library
- You will likely need to get the appropriate URL from your IT department; they will need to give you the permission to deploy
- There are a number of other options to save your report; e.g. Desktop, My Documents and My Computer
- To review the steps required to install and configure SSRS in SharePoint Integrated mode, take a look at the tips Integrating SQL Server 2008 R2 Reporting Services with SharePoint 2010 or SQL Server Reporting Services Integration with SharePoint. There are a few steps that are required to get a document library setup with the appropriate content types for reports; these steps are covered in the first tip.
Last Update: 6/23/2011