Learn more about SQL Server tools



solving sql server problems for millions of dbas and developers since 2006 join MSSQLTips for free SQL Server tips



















   Got a SQL tip?
            We want to know!


Report Builder Deploying Reports  

Overview

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.

Explanation

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

Additional Information



 
Sponsor Information







Copyright (c) 2006-2014 Edgewood Solutions, LLC All rights reserved
privacy | disclaimer | copyright | advertise | about
authors | contribute | feedback | giveaways | free t-shirt | user groups | community | events | first timer?
Some names and products listed are the registered trademarks of their respective owners.