Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 disabling export option in SQL report services

Author  Topic 

jim_cool
Starting Member

43 Posts

Posted - 2005-12-16 : 06:52:10
hi all

there is one way by which we can hide the item in Export list that is displayed when report is run.
that is as follows :
goto
\Program Files\Microsoft SQL Server\MSSQL\Reporting Services\ReportServer\RSReportServer.config

open file in notepad and search for given string and make the Visible ="false"

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

Now the problem is that , this trick hides Excel option in Export list for all reports.

But i want to hide this option only for selected reports.
So what shud i do
Plz help me..
Waiting for reply
   

- Advertisement -