Skip to content

publish-a-report-to-a-sharepoint-library.md

Latest commit

 

History

History
48 lines (34 loc) · 3.58 KB

publish-a-report-to-a-sharepoint-library.md

File metadata and controls

48 lines (34 loc) · 3.58 KB
title Publish a Report to a SharePoint Library
description Learn how to publish a report to a SharePoint library by setting the project properties in Report Designer.
ms.date 09/25/2024
ms.service reporting-services
ms.subservice reports
ms.topic how-to
ms.custom
updatefrequency5
helpviewer_keywords
deploying [Reporting Services], reports in SharePoint integrated mode
SharePoint integration [Reporting Services], publishing to a library
publishing reports [Reporting Services], to a SharePoint library

Publish a Report to a SharePoint Library

To publish a report to a SharePoint site configured for SharePoint integration, you must set the project properties in Report Designer. In the project properties, all references to servers, reports, and shared data sources must be fully qualified URLs. In the report definition, all references to subreports, drillthrough reports, and resources such as Web-based images, must be fully qualified URLS.

You must have Member or Owner permission on the SharePoint site to set the properties on the project. For more information, see URL Examples for Published Report Items on a Report Server in SharePoint Mode (SSRS).

To publish a report to a SharePoint site

  1. In [!INCLUDEssBIDevStudioFull], open an existing or new Report Server project.

  2. From the Project menu, click Properties. The <project>Property Pages dialog box opens.

  3. In the Configuration list, select the name of a solution build configuration to use to build and publish your report. The current configuration is listed as Active(<configuration>).

  4. If you want to publish the shared data sources in your project and overwrite previously published shared data sources, set OverwriteDataSources to True.

  5. (Optional) For TargetDataSourceFolder, type a URL to a SharePoint library or library folder (for example, https://TestServer/TestSite/Documents/DataSources).

    If you do not specify a value, the TargetReportFolder value is used.

  6. For TargetReportFolder, type a URL to a library or library folder (for example, https://TestServer/TestSite/Documents/Reports).

  7. For TargetServerURL, type a URL to a SharePoint top-level site or subsite. If you do not specify a site, the default top-level site is used (for example, https://servername, https://servername/site, or https://servername/site/subsite).

  8. Select OK.

  9. In Solution Explorer, right-click the report you want to publish, and click Deploy. The report is published to the location specified in TargetReportFolder. Deployment errors appear in the Output window.

Related content