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

title	description	author	ms.author	ms.date	ms.service	ms.subservice	ms.topic	ms.custom	monikerRange
Configuration and administration of a report server	With SQL Server Reporting Services, you can integrate your reporting environment with a SharePoint product to use collaboration provided by SharePoint sites.	maggiesMSFT	maggies	09/25/2024	reporting-services	report-server-sharepoint	conceptual	updatefrequency5	>=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