SSRS Export option

Question

Post reply

SSRS Export option

deepak.a

SSCertifiable

Points: 5330
More actions
September 14, 2011 at 12:57 am

#243690

Hi All,
Is it possible to restrict the export options available in ssrs ?. I got a requirement like i need to display only CSV and excel file export option. by Default we will get so many export option like CSV, XML, EXCEL , WORD , PDF etc..,
Thanks & Regards
Deepak.A

Viewing 10 posts - 1 through 9 (of 9 total)

You must be logged in to reply to this topic. Login to reply

activesoma SSC Enthusiast Points: 114 More actions · Answer 1

Yes it is possible.

Edit the file rsreportserverconfig

and enable what ever you want to get listed.

deepak.a SSCertifiable Points: 5330 More actions · Answer 2

hi activesoma,

Thanks for your reply , if i edit the report config it will reflect to all reports , i want to restrict only for selected reports is that possible ?

Regards - Deepak.A

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 3

I'm really hoping someone knows this because I could use that as well.

Right now the only idea I have is to put the render mode in the url. That way you'd default the report to only web display and then using another link "default that" to csv or pdf or whatever you need for that particular report.

deepak.a SSCertifiable Points: 5330 More actions · Answer 4

Hi Ninja,

Thanks for the reply is there any other way do this , because user wants to see the export option in lists

Regards - Deepak

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 5

deepak.a (9/14/2011)
Hi Ninja,
Thanks for the reply is there any other way do this , because user wants to see the export option in lists
Regards - Deepak

Really streching it here.

More than 1 instance of ssrs?

The only other idea I have is an asp .net application that shows reports with reportviewer control. In which case you could control that afaik (don't quote me on this this).

activesoma SSC Enthusiast Points: 114 More actions · Answer 6

Hi

It is possible in SQL Server 2008 R2

Go through the link for the step by step process.

http://www.mssqltips.com/sqlservertip/2106/conditional-report-rendering-based-on-render-formats-for-ssrs-reports/

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 7

activesoma (9/14/2011)
Hi
It is possible in SQL Server 2008 R2
Go through the link for the step by step process.
http://www.mssqltips.com/sqlservertip/2106/conditional-report-rendering-based-on-render-formats-for-ssrs-reports/

Awesome.

Another good reason to ask for the upgrade around here!!

deepak.a SSCertifiable Points: 5330 More actions · Answer 8

Ninja's_RGR'us (9/14/2011)
activesoma (9/14/2011)
Hi
It is possible in SQL Server 2008 R2
Go through the link for the step by step process.
http://www.mssqltips.com/sqlservertip/2106/conditional-report-rendering-based-on-render-formats-for-ssrs-reports/
Awesome.
Another good reason to ask for the upgrade around here!!

Thanks activesoma , but i'm looking this in SSRS 2005/2008

Regards - Deepak

Ninja's_RGR'us SSC Guru Points: 294069 More actions · Answer 9

As I said, good argument to look at an upgrade... maybe wait 'till denali (you can always only upgrade the ssrs side of things which makes the upgrade easier to make and less labor sensitive).