December 19, 2010 at 1:25 pm
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
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
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.
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply