SSRS - Disabling export options (eg. PDF) for individual reports
We have many reports which we use on the website. While exporting some reports as PDF, the file size gets huge and the server crashes due to load. So it would be great if I can disable export to PDF option only for certain problematic reports.
So is there a way to disable certain export options (example: export to PDF) in report viewer 9.0 (SSRS), for individual reports?
Thank you.
Answer
Just in case nobody else said it out loud before here or in linked articles:
The neatiest global solution is to find the rendering engines in the RS config file (mine sits in: C:\Program Files\Microsoft SQL Server\MSRS12.MSSQLSERVER\Reporting Services\ReportServer\rsreportserver.config), go to xml key: Extensions > Render and insert following property at the end of each entry you want to hide:
Visible="false"
Example:
<Extension Name="XML" Type="Microsoft.ReportingServices.Rendering.DataRenderer.XmlDataReport,Microsoft.ReportingServices.DataRendering" Visible="false"/>
Alternatively put <!-- and --> (HTML comment markers) at the beginning and end of the entry.
For individual reports those functions will do the trick.