Post reply

Export in reporting services

  • December 19, 2010 at 1:25 pm

    #244495

    Hi,

    is there any way to block some report export like downloading it in excel.

    if it is how to do it.

    Regards
    Durai Nagarajan

  • December 20, 2010 at 7:17 am

    #1264611

    I believe you can find export options in the RSReportServer.config file. If I am not mistaken you can remove the formats you do not want to be available. As always, have a back up copy before editing your file.

  • December 20, 2010 at 7:29 am

    #1264622

    To elaborate on what dbowlin said...

    In the rsreportserver.config XML (located for 2005 anyhow... %Program Files%\Microsoft SQL Server\[instance folder]\Reporting Services\ReportServer) file you can edit the following...

    Under the <extensions><Render> hive...

    anything that you do not want to appear can be hidden using the Visible="false" options...

    so instead of:

    <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering"/>

    You'd use

    <Extension Name="EXCEL" Type="Microsoft.ReportingServices.Rendering.ExcelRenderer.ExcelRenderer,Microsoft.ReportingServices.ExcelRendering" Visible="false"/>

    It is important to note that this will hide that rendering extension for all users and all reports if you do it this way. If you just want to do it on a per report basis there are a variety of ways listed here...http://www.sqldev.org/sql-server-reporting-services/remove-export-options-from-reportviewer-control-13342.shtml

    EDIT: And a second on the make a copy of the file before you modify it so you have a backup in case it gets hosed...

    -Luke.

    To help us help you read this[/url]For better help with performance problems please read this[/url]

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply