If you come across a issue where you can't see SSRS Content types in your site, then first thing to try would be to deactivate and active the site collection feature "Report Server Integration Feature".

If you still have issues and can't see them and reckon there's some issues with configuration, then try re-installing the content types by following the instructions provided in link below:

http://technet.microsoft.com/en-us/library/aa905871.aspx#bkmk_install_rssharepoint

Below is the excerpt from the article.

Files-only installation

To install the files but skip the custom action phase of installation, run the rssharepoint.msi from the command line with the SKIPCA option:

  • Open a command prompt with administrator permissions.
  • Run the following command:

Msiexec.exe /i rsSharePoint.msi SKIPCA=1

The installation user interface will open and run as normal and the rsCustomAction.exe file is installed. However, the .exe will not run at the end of the installation and rsCustomAction.exe will remain on the computer when the installation is completed.Arrow icon used with Back to Top link

Use a two-step installation to troubleshoot installation issues or install the content types

If you get errors during installation or the Reporting Services content types do not appear in the document library settings, you can run Setup as a two-step process from the command line:

  • Open a command prompt with administrator permissions and run a files only installation as described in the previous section.
  • Run the custom actions executable:
  • Navigate to the folder that contains the file rsCustomAction.exe. This file is copied to your computer by the files only installation of the add-in. rsCustomAction.exe is located in the %Temp% directory. To navigate to the file, type the following from the command prompt:

CD %temp%.

The file should be located in: Users\AppDataLocalTemp

  • Type the following command. This configuration step will take several minutes to finish. The W3SVC service will be restarted during this process. Several Status messages will be displayed as the program copies files, registers components, and runs the SharePoint Product Configuration Wizard.
rsCustomAction.exe /i
  • The amount of time it takes for the changes to take effect may vary, depending on your server environment. You can also run iisreset to force a quicker update.

Hopefully, after this your content types will appear.

Hopefully, after this your content types will appear.

Leave a Reply

Your email address will not be published. Required fields are marked *