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.