In this article, you will learn how to activate the Report Server Integration feature. For On-premise Customers, if the Report Server Integration feature is not available on the list of Site Collection features, the SSRS Integrated Mode installation is not set up correctly. The Reporting Services Add-in for SharePoint has to be installed. The Microsoft SQL Server Reporting Services Add-in for Microsoft SharePoint Technologies is a Web download that provides features for running a report server within a larger deployment of SharePoint Foundation and SharePoint Server 2010. Once the Report Server Integration Feature has been activated, a new Reporting Services menu will show on the Site Settings page.
Note: On newly created EPM Live Site Apps (site collections), this feature is activated by default.
1. Open Advanced SharePoint Administration
- Select the Settings Gear icon on the Icon Bar.
- Under the Settings heading, select SharePoint Site Settings.
2. Open Site Collection Features
Under the Site Collection Administration heading, select Site Collection Features.
3. Activate the Report Server Integration Feature
If needed, select the Activate or Deactivate button to activate or deactivate this site collection feature.