After installing the Reporting Services Add-in for Integration with SharePoint, you may find that the Reporting Services features are not visible in your SharePoint web sites. Why does this happen? Because when the add-in is installed, it is only activated for the sites in the default Site Collection.
Steps to resolve:
- Bowse to the ‘Home’ or root URL of the site collection.
- Click on Site Actions –>Site Settings –> Site Collection Features.
- Choose the “Reporting Services Integration” feature, under the list of features for Site “Collection Features”.
- Press the “Activate” button.
Note: You will need to be owner of the site collection in order to view the “Site Collection features” link.