How to Disable/restrict SSRS Export format ?

Leave a comment (1) Go to comments

SQL Server Reporting Services (SSRS) supports export to different formats like XML, CSV, HTML, PDF, etc., when you view the report.  This export option is available at report viewer Export drop-down list.

We can control this via report services server configuration file which is available at "C:\Program Files\Microsoft SQL Server\MSSQL.2\Reporting Services\Report Server\ rsreportserver.config".

Location can be changed, based on installation location of Reporting services.

In This File, In <Render /> tag elements, add attribute Visible="false" and save the file. Now if you check, it won’t be available at Export drop-down list

Example:

<Render>
<Extension Name="XML"
Type="Microsoft.ReportingServices.Rendering.XmlDataRenderer.XmlDataReport,Microsoft.ReportingServices.XmlRendering" Visible="false" />
</Render>
EOF - How to Disable/restrict SSRS Export format ?, SQL Server 2012 , 2008 R2 , 2008 , 2005 , 2000
Leave a comment

1 Comments.

  1. Thx for sharing this. I understand this option is @ the server level, Is there a way of controlling formats @ Report level.
    Like for Report 1 , Export to CSV, Excel ONLY should be enabled
    Report 2, Export to Excel ONLY should be enabled
    Report 3, All formats should be visible/enabled.

    Thanks,
    Aravind

Leave a Reply

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


*


You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Notify me of followup comments via e-mail. You can also subscribe without commenting.