For the majority of reports our users access it is fine for them to download and manipulate the data; however we have a few reports that should ideally only be read only. Is it possible to limit the export types on a per report basis, to pdf? We are using SQL2008R2 & Report Builder 3.0. In the thread "Limit report from being exported to excel" Jim Chen suggested adding Javascript to achieve something similar. I would have concerns on how "hack proof" this solution would be and as we have multiple environments this work around would add significantly to the complexity of deployments. The best I could come-up with is using the RenderFormat property and hiding reporting components if not output in pdf. However this solutions seems a little inelegant, error prone and a lot like hard work! ;-) As a newbie the answer is probably "staring me in the face" so apologies if this is a dumm question. Regards Steve D

Hi Steve, As you posted, the possible workaround is to use JavaScript to “hack” the Report.aspx page of Report Manager or to hide contents in the report based on the RenderFormat property. However, since both approaches have limitations and there is no built-in feature to limit the export types on a per report basis, please submit your suggestion about this issue at https://connect.microsoft.com/SQLServer/. Your feedback is valuable for us to improve our product and service level. Thank you for sharing your idea and we appreciate your understanding. Regards, Tony ChainTony Chain [MSFT] MSDN Community Support | Feedback to us Get or Request Code Sample from Microsoft Please remember to mark the replies as answers if they help and unmark them if they provide no help.

The alternative to this is to control the report rendering via an ASP.NET application - it would be a relatively simple matter to allow users to choose from a list of reports and have the report render for them in PDF (for those that are read only) or in "native" web mode for those that are allowed to be exported The rendering can be done wholly in .NET to PDF which would therefore not expose any ability to the user to view the report in any other format A simple IF statement to check selected report against a list of read only reports could be used to either do the report generation programmatically or simply direct the user to the standard report manager interface for those reports that are available in any render formatRgds Geoff

The alternative to this is to control the report rendering via an ASP.NET application - it would be a relatively simple matter to allow users to choose from a list of reports and have the report render for them in PDF (for those that are read only) or in "native" web mode for those that are allowed to be exported The rendering can be done wholly in .NET to PDF which would therefore not expose any ability to the user to view the report in any other format A simple IF statement to check selected report against a list of read only reports could be used to either do the report generation programmatically or simply direct the user to the standard report manager interface for those reports that are available in any render formatRgds Geoff

Hi Tony/Geoff Thanks for the feedback; at least I hadn't missed the obvious. ;-) Have raised via Microsoft Connect. Regards Steve D