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
 Development Tools
 Reporting Services Development
 disabling export option in Report Serveices

Author  Topic 

jim_cool
Starting Member

43 Posts

Posted - 2005-12-16 : 01:45:00
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

jhermiz

3564 Posts

Posted - 2005-12-16 : 09:51:35
quote:
Originally posted by jim_cool

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



You cannot do that for ALL reports, you will have to either have it or not have it. Your next option is to write code to handle the type of format but I am not too familiar with the RS object model to help in that area.

Jon



Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]
Go to Top of Page
   

- Advertisement -