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

Applies to:  SQL Server Reporting Services (2016)  SharePoint ❌ Power BI Report Server

For content related to previous versions of SQL Server Reporting Services (SSRS), see What is SQL Server Reporting Services?

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