configuration-and-administration-of-a-report-server.md

title	Configuration and administration of a report server
description	With SQL Server Reporting Services, you can integrate your reporting environment with a SharePoint product to use collaboration provided by SharePoint sites.
ms.date	09/25/2024
ms.service	reporting-services
ms.subservice	report-server-sharepoint
ms.topic	concept-article
ms.custom	updatefrequency5
monikerRange	>=sql-server-2016 <=sql-server-2016

Configuration and administration of a SQL Server Reporting Services (SSRS) report server

[!INCLUDEssrs-appliesto] [!INCLUDEssrs-appliesto-2016] [!INCLUDEssrs-appliesto-sharepoint-2013-2016i] [!INCLUDEssrs-appliesto-not-pbirsi]

[!INCLUDE ssrs-previous-versions]

SQL Server Reporting Services is a server-based reporting platform. It provides a full range of ready-to-use tools and services to help you create, deploy, and manage reports for your organization. It also provides programming features that enable you to extend and customize your reporting functionality. You can integrate your reporting environment with a SharePoint product to experience the benefits of using the collaborative environment provided by SharePoint sites.

Note

Reporting Services integration with SharePoint is no longer available after SQL Server 2016.

Use the following sections to help you understand concepts, deployment scenarios, procedures, and more for integrating your Reporting Services environment with a SharePoint product or technology:

• Menu options in a SharePoint document library

  • Data Alert Manager for SharePoint users

  • Create and manage subscriptions for SharePoint Mode Report Servers

  • Update credentials in report data sources from a SharePoint site

  • Manage Shared Datasets

  • Set parameters on a published report (Reporting Services in SharePoint Integrated Mode)

  • Set processing options (Reporting Services in SharePoint Integrated Mode)

• Reporting Services site collection features

• Activate the report server and Power View integration features in SharePoint

• Reporting Services site settings and site features(SharePoint Mode)

• Activate the report server File Sync feature in SharePoint Central Administration

• Add Reporting Services content types to a SharePoint library

• Local Mode vs. Connected Mode reports in the Report Viewer (Reporting Services in SharePoint Mode)

• Upload documents to a SharePoint library (Reporting Services in SharePoint mode)

• Set processing options (Reporting Services in SharePoint integrated mode)

More questions? Try asking the Reporting Services forum