How to: Publish a Report to a SharePoint Library (Report Builder 2.0)

To publish a report to a report server configured for SharePoint integration, you must browse to the SharePoint server and establish a connection to the report server. In the report definition, all references to items related to the report must use values that are specific to a SharePoint report server. Related items include subreports, drillthrough reports, and resources such as Web-based images. For more information, see Specifying Paths to External Items (Report Builder 2.0).

You must have Member or Owner permission on the SharePoint site to set the properties on the project. For more information, see Viewing and Managing Report Server Items from a SharePoint Site (Report Builder 2.0).

On a SharePoint site, you can use existing office data connections (.odc) as data sources. For more information, see "How to: Use an Office Data Connection (.odc) with Reports (Reporting Services in SharePoint Integrated Mode)" in the Reporting Services documentation in SQL Server Books Online.

To publish a report to a SharePoint site

  1. From the Report Builder button, click Save. The Save As<Report Item> dialog box opens.

  2. Browse to the SharePoint site, and then click Save. For report server URL examples, see Report Servers and SharePoint Report Servers (Report Builder 2.0).