How to disable Export Options in SQL Reports?
Submitted by admin on Wed, 02/24/2010 - 16:59
Posted in
Using SQL Reports is Fun. I have been having fun using it recently. It’s pretty cool.
Wanted to figure out how to disable the Export Options in the SQL Reports when it is displayed to the user in Report Viewer. To be more specific I wanted to disable exporting in .pdf format. After looking around for it found out it can be done in the rsreportserver.config file.
You should find the rsreportserver.config under C:\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer
Open the config file and go to the Render Section. Within Render you should have the Extension element. You have Extension element for different Export file formats. In my case I want to disable the .pdf file format. Just add the Visible=”false” to the Extension Element for PDF. It should looking something like this.
<ExtensionName="PDF"Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering" Visible="false"/>Please note, the changes made in the config file affects all the reports on the Resport Server, so be cautious when using this option. If you want this to be applied just to a single report, this will not work, you might rather use the Report Viewer Control available in Visual Studio
Also remember after making this change to the config file still if you see the .pdf option in the Export drop down list in the Report Viewer, Try Restarting IIS . That should work.
Have a Nice Day
Robert