Reporting Services Report Server (SharePoint Mode)

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?

A Reporting Services report server configured for SharePoint Mode can run within a deployment of a SharePoint product. A report server in SharePoint mode can use the collaboration and management features of SharePoint for reports and other Reporting Services content types. SharePoint mode requires installing the appropriate version of the Reporting Services add-in for SharePoint products on your SharePoint Web Front Ends.

Note

Reporting Services integration with SharePoint is deprecated after SQL Server 2016. To add Reporting Services reports to SharePoint, use the Report Viewer web part.

For more information on installing and configuring, see the following articles:

Feature summary

Configuring a report server to run in SharePoint integrated mode provides the following functionality that's only available when you deploy a report server in this mode:

  • Use SharePoint document management and collaboration features, including alerts. A SharePoint site provides a unified portal for accessing and managing all report items in one place.

  • Use SharePoint permissions and authentication providers to control access to reports, models, and other items.

  • Use SharePoint deployment topologies to distribute reports over an Internet connection outside the firewall. A report server provides report and data processing services in the context of a larger SharePoint deployment that is configured for Internet access.

  • Manage reports, models, data sources, schedules, and report history in custom application pages on a SharePoint site. You can set properties, define schedules and subscriptions, and create and manage report history on a SharePoint site the same way you create and manage them from other tools in SQL Server.

  • Publish or upload reports, report models, resources, and shared data source files to a SharePoint library, including Report Center in Office SharePoint Server.

    Use Report Designer, Model Designer, and Report Builder to create reports and data sources to be published directly to a SharePoint library. You can also use the Upload action on a SharePoint site to add any report definitions and report models to a SharePoint library.

    Because the report server processes report definitions in the same way regardless of the server mode you use, the report data and layout is unaffected by server mode. Any report that you can run in a native mode report server can run on a report server that is configured for SharePoint integrated mode.

  • Subscribe to and deliver reports to a SharePoint library using a new SharePoint delivery extension. You can also deliver reports through e-mail or to a shared folder. The report server delivery extensions are used to deliver reports. You can create data-driven subscriptions for large-scale report distribution using subscriber data queried at run time.

  • A Report Viewer web part you can add to SharePoint pages to view a report inside your SharePoint web application. The web part includes page navigation, search, print, and export features.

  • Program against a new SOAP endpoint to create custom applications that integrate with a SharePoint site. You can also use the updated Windows Management Instrumentation (WMI) provider to programmatically configure a report server instance that runs in SharePoint integrated mode.

  • Microsoft Access services reporting, in connected mode.

  • AAM zones, internet facing deployments, and SharePoint user tokens for SharePoint lists.

Connected mode and local mode

The SQL Server 2008 R2 release introduced a new local mode for viewing reports from a SharePoint 2010 server that has the Microsoft SQL Server 2008 R2 or later Reporting Services add-in for SharePoint 2010 products installed.

  • Local Mode: Local mode allows reports to be rendered locally from the SharePoint document library, without integration with a Reporting Services report server. The Reporting Services add-in for SharePoint products is required but a Reporting Services report server isn't required. The add-in can be installed several different ways, including the SharePoint 2010 products preparation tool. For more information on local mode, see Local mode vs. connected mode reports in the Report Viewer and Where to find the Reporting Services add-in for SharePoint products.

  • Connected Mode: Connected mode is supported by integrating a Reporting Services report server into the SharePoint farm using SharePoint Central Administration. The integration with a report server enables full end-to-end reporting, providing the collaboration features of SharePoint 2010 and the server based features of a report server including: Subscriptions, Snapshots, and server based processing.

Unsupported SharePoint features

Not all SharePoint features are available for integrated operations. The following list is a list of the SharePoint features Reporting Services doesn't directly integrate with:

  • Secure Store Service.

  • You can't use the SharePoint Outlook Calendar integration or the SharePoint scheduling for reporting services files in a document library.

  • SharePoint Business Data catalog.

  • SharePoint personalization is also not supported on the Reporting Services pages. Report Server integration isn't supported if the SharePoint Web application is enabled for Anonymous access.

  • SQL Server Reporting Services doesn't* support SharePoint document library version control. If you save report items in a document library that's configured with "Document Version History" enabled, Reporting Services features don't function correctly and generate errors in the ULS log. The following example is of an error in the ULS log:

    • "...a data source associated with the report has been disabled."

    Document library version history is configured on the "Versioning Settings" page of "Library Settings."

Supported combinations of the SharePoint add-in and report server

Not all features are supported in all combinations of report server, Reporting Services add-in for SharePoint, and SharePoint Products. For more information, see Supported combinations of SharePoint and Reporting Services Server and add-in.

Note

The correct version of the Reporting Services add-in must be used with the corresponding version of SharePoint Products.

Components that provide integration

To combine the servers in a single deployment, you integrate an installation of SQL Server Reporting Services with an instance of SharePoint products.

Integration is provided through SQL Server and the Reporting Services Add-in for SharePoint Products. The Reporting Services Add-in is a freely distributable component that you can download and then install on a server that is running the appropriate version of SharePoint.

Tip

Not all features are supported in all combinations of report server, Reporting Services add-in for SharePoint, and SharePoint Products. For more information, see Supported combinations of SharePoint and Reporting Services Server and add-in.

  • On SharePoint, the Reporting Services add-in provides the ReportServer proxy endpoint, a Report Viewer web part, and application pages so that you can view, store, and manage report server content on a SharePoint site or farm.

  • On Reporting Services provides updated program files, a SOAP endpoint, and custom security and delivery extensions. The report server must be configured to run in SharePoint integrated mode, dedicated exclusively to supporting report access and delivery through your SharePoint site.

After you install the Reporting Services add-in on SharePoint and configure the two servers for integration, you can upload or publish report server content types to a SharePoint library. You can then view and manage those documents from a SharePoint site. Uploading or publishing report server content is an important first step; the web part and pages become available when you select report definitions (.rdl), report models (.smdl) and shared data sources (.rsds) on a SharePoint site.

Language considerations

SharePoint Foundation 2010 and SharePoint Server 2010 products are available in many more languages than SQL Server

When you configure a report server to run within a deployment of a SharePoint product, you might see a combination of languages. The user interface, documentation, and messages appear in the following languages:

  • All application pages, tools, errors, warnings, and messages that originate from Reporting Services appear in the language used by the Reporting Services instance in one of the SQL Server languages.

  • Application pages that you open on a SharePoint site, the Report Viewer web part, and Report Builder appear in one of the supported languages for the Reporting Services Add-in. To view the list of supported languages, go to SQL Server downloads and find the download page for the SQL Server 2016 Reporting Services Add-in.

  • SharePoint sites, SharePoint Central Administration, online help, and messages are available in the languages supported by Office Server products.

If the language of your SharePoint product or technology differs from the report server language, Reporting Services tries to use a language from the same language family that provides the closest match. If a close substitute isn't available, the report server uses English.

The following table summarizes tasks related to a Reporting Services SharePoint mode report server:

Task Link
Detailed steps for installing and configuring Reporting Services in SharePoint mode. Install Reporting Services SharePoint mode for SharePoint 2010 and Add another Report Server to a farm.
Scale out your Reporting Services SharePoint deployment by adding more report servers. Add another Report Server to a Farm and Deployment topologies for SQL Server BI features in SharePoint.
Add more SharePoint web front-ends that have the Reporting Services components installed for viewing and report items. Add another Reporting Services web front-end to a farm
Configure e-mail for your report server within SharePoint. Configure e-mail for a Reporting Services service application