Hiding SQL Server 2012 Reporting Services Extensions in SharePoint

To continue my Report Server Settings in SQL Server 2012 SharePoint Integration Mode blog, here is another example of how to use the new PowerShell-based configuration mechanism to hide a rendering extension. In this case, the script finds an SSRS application called SQL Server SSRS (replace with the name of your SSRS application from SharePoint Central Admin) and hides the XML renderer so the XML export option doesn’t appear in the Actions drop-down.

$apps = Get-SPRSServiceApplication  | where {$_.name -like “SQL Server SSRS”}

Set-SPRSExtension -identity $apps -ExtensionType “Render” -name “XML” -ExtensionAttributes “<Visible>False</Visible>”