How to: Activate the Report Server Feature in Site Settings
The Report server integration feature is automatically activated after you install the Microsoft SQL Server 2008 R2 Reporting Services Add-in for SharePoint products. In some situations you will need to manually activate the feature. To activate the report server feature, use the Site collection features page from site settings.
If the Reporting Services feature does not appear in the site collection feature list, the Reporting Services Add-in is not installed.
To verify installation, view the list of installed applications in Microsoft Windows Control Panel. If the Reporting Services Add-in is installed, follow the instructions in this topic to activate the feature.
By default, the Reporting Services Add-in is activated for the root site collection of the local SharePoint Web application. If the root site is not enabled or if you do not have a site collection defined when the Reporting Services Add-in is installed, you must activate the report server integration settings manually.
The SQL Server 2008 R2 Reporting Services version and later of the Add-in for SharePoint products will activate the report server integration feature for all existing site collections when the Add-in is installed. Additionally, the feature will be automatically active for new site collections.
To activate or deactivate Reporting Services integration on a Site Collection
Click Site Actions.
Click Site Settings.
Click Site Collection Features in the Site Collection Administration Group.
Find Report Server Integration Feature in the list.
To deactivate the features, you can use the same procedure, but click Deactivate rather than Activate.
After the feature is activated, you can continue with server integration. For more information, see How to: Configure Report Server Integration in SharePoint Central Administration.