Report Viewer - Hide PDF Export

I always like to share simple but interesting solutions to the users who are in urgent need of fixing it.Here I am going to share, how one can achieve hiding some of the options available from the Export options of Report Viewer from SQL Reporting Services.

I did the following to achieve this.

Steps:

1. Go to file "rsreportserver.config".

This file you can find in location "C:\Program Files\Microsoft SQL Server\MSSQL.1\Reporting Services\ReportServer"

2. Go to the section <Render>.

3. Add the Visible="false" attribute to the end of each Extension tag to which you wish to hide.

For Example:

Here I am hiding PDF option and keeping all other options enabled.

<Extension Name="PDF" Type="Microsoft.ReportingServices.Rendering.ImageRenderer.PdfReport,Microsoft.ReportingServices.ImageRendering" Visible="false"/>

After applying these settings you will see only Excel option enabled.

Note: Since these settings are applied to the report server configuration file so changes will be reflected to all reports.

:) Is it not easy?

You comments are always appreciated.