Customize Actions on the RSViewerPage.aspx

When working with Reporting Services 2005 integrated with Sharepoint 2007 , you will come across a lot of questions about how can i hide this option, i want the users to be able to export only to PDF and Excel .... Ok here's some tricks to do couple of things like that:




1- How to customize what export options to show from your Actions menu:




























- From your Reporting Services Server go to :


Install_Drive\Program Files\Microsoft SQL Server\MSSQL.3\Reporting Services\ReportServer
- Open rsreportserver.config


- Go to the render section as shown below:

- Comment/ Uncomment options that you want to show/hide

(commented options will be hidden )

2- How to Hide the Print Icon from Actions

From your Reporting Services Database open the ConfigurationInfo table

and set EnableClientPrinting to False this will hide the Print Icon