Reporting Services site settings and site features (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 SQL Server 2014 Reporting Services.

Reporting Services SharePoint mode has several site level custom features and site feature that can be managed from the SharePoint Site Settings page. The settings are site wide and affect all Reporting Services service applications. You must have Content Manager and System Administrator permissions to view this page.

Note

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

Site Setting Description
Reporting Services Site Settings Site-wide settings described in this article.
Manage Data Alerts Management of the Data Alerting feature.
Report Server File Sync A Site level feature that is deactivated by default.

Synchronizes Report Server files (.rdl, .rsds, .smdl, .rsd, .rsc, .rdlx) from a SharePoint document library to the report server when files are added or updated in the directly within the document library.

For more information, see Activate the Report Server File Sync Feature in SharePoint Central Administration

Open the Reporting Services site settings page

  1. From the SharePoint site's Site Actions menu, select Site Settings.

  2. In the Reporting Services section, select Reporting Services Site Settings.

Options for Reporting Services site settings

Option Description
Enable RSClientPrint ActiveX control download The control displays a custom print dialog box that supports features common to other print dialog boxes, including print preview, page selections for specifying specific pages and ranges, page margins, and orientation. For more information on the control, see Using the RSClientPrint Control in Custom Applications
Enable remote errors in local mode Show or hide detailed error messages on remote computers when running in local mode. If you see an error message similar to the following, then enabling remote errors might be useful:

For more information about this error navigate to the report server on the local server machine or enable remote errors
Enable accessibility metadata for reports Turn on accessibility metadata in the HTML output for reports
Enable Exact Data Visualization Fit Sizing for Reports Configure data visualization fit behavior when inside a tablix, to fix exactly. This includes chart, gauge, and map. When disabled the behavior is for data visualizations to fit approximately, which might leave some white space. This setting only applies to rendering in the Report Viewer web part. To manage this behavior for server-side rendering, you need to modify the rsreportserver.config file. For more information, see the following articles:

RsReportServer.config Configuration File.

Customize Rendering Extension Parameters in RSReportServer.Config.

HTML Device Information Settings.

Enabling Exact might affect performance because the processing to determine the exact size might take longer than an approximate fit.

Manage a Reporting Services SharePoint service application