Limiting Export Options Per Report

Question

Limiting Export Options Per Report

fstop

Default port

Points: 1482
More actions
October 2, 2015 at 12:48 pm

#321157

Does anyone know how to limit the export options per report? When using URL access for a report, I would like to have the report open in the HTML Viewer with only a single export option (such as Excel). Is there a way to do this per report rather than editing the rsreportserver.config file, which would limit the export options for all reports.
As an alternative, I've read that you can use URL parameters to bypass the HTML Viewer entirely. In Leo Tachev's book "Applied MS SS 2008 Reporting Services", he mentions adding a parameter to the URL to bypass the HTML Viewer and open the report in the desired export/rendered option: &rs:Command=Render&rs:Format=Excel. Using these parameters doesn't change anything in my testing. The report still opens in the HTML Viewer. Does anyone know how to make this work?
Forum Etiquette: How to post Reporting Services problems

[/url]

Forum Etiquette: How to post data/code on a forum to get the best help - by Jeff Moden
[/url]

How to Post Performance Problems - by Gail Shaw
[/url]

mister.magoo SSC-Forever Points: 47068 More actions · Answer 1

I don't think there is any way to restrict the options in the drop down, but if you are happy to just make it not export for the other options, you could set the visibility of your report items based on the format, i.e. make them invisible for anything other than excel.

= IIf( Globals!RenderFormat.Name = "Excel" Or Globals!RenderFormat.IsInteractive, False, True )

MM

select geometry::STGeomFromWKB(0x0106000000020000000103000000010000000B0000001000000000000840000000000000003DD8CCCCCCCCCC0840000000000000003DD8CCCCCCCCCC08408014AE47E17AFC3F040000000000104000CDCCCCCCCCEC3F9C999999999913408014AE47E17AFC3F9C99999999991340000000000000003D0000000000001440000000000000003D000000000000144000000000000000400400000000001040000000000000F03F100000000000084000000000000000401000000000000840000000000000003D0103000000010000000B000000000000000000143D000000000000003D009E99999999B93F000000000000003D009E99999999B93F8014AE47E17AFC3F400000000000F03F00CDCCCCCCCCEC3FA06666666666FE3F8014AE47E17AFC3FA06666666666FE3F000000000000003D1800000000000040000000000000003D18000000000000400000000000000040400000000000F03F000000000000F03F000000000000143D0000000000000040000000000000143D000000000000003D, 0);

Spiff SSCertifiable Points: 7766 More actions · Answer 2

Hi fstop,

I don't think you can limit the drop down except with globally through the config, however there is no reason the URL access shouldn't work.

Couple of things to check with your URL access. It's not just a case of appending the parameters to the URL you see when browsing through the report manager, you have to access via the report service not the report viewer control i.e.

http://myreportserver/ReportServer/..

Not http://myreportserver/Reports/

You also need to encode the report path in the URL, e.g. / = %2f, + = Space etc . Note there is also no "ItemPath=" parameter.

The URL should look something like:

http://myreportserver/ReportServer?%2fMy+Folder%2fMy+Report&rs:Format=Excel

HTH

fstop Default port Points: 1482 More actions · Answer 3

Thanks for your input. The only way this works for me is with the following URL:

'http://myreportserver/ReportManager/Pages/Report.aspx?ItemPath=%2fMyReportName&rs:Format=Excel' (although &rs:Format=Excel doesn't seem to have any effect on the outcome...it's the same as using &ViewMode=Detail). An HTML Viewer is created which has the parameters for the user to enter, and the report is created in that window.

I tried removing ItemPath like you suggested, but that wouldn't work. I also tried 'http://myreportserver/ReportServer', but that only gave me a listing of links to the reports on the report server.

So it looks like I'm still in the same place. Any other suggestions would be greatly appreciated.

Spiff SSCertifiable Points: 7766 More actions · Answer 4

Did you try:

http://myreportserver/ReportServer?%2fMy+Folder%2fMy+Report&rs:Format=Excel%5B/b%5D

fstop Default port Points: 1482 More actions · Answer 5

I did, but as stated above that only gave me a listing of links to the reports on the report server.

Spiff SSCertifiable Points: 7766 More actions · Answer 6

This below link pretty much covers what I've been getting at, though they don't seem to encode the URL the same way. If you are getting the list of reports it must be something with the stuff after the ?. I've just successfully run a similar URL against my report server, which is a fairly vanilla native-mode install. If it's not your URL I don't know what's going wrong, soz.

https://msdn.microsoft.com/en-us/library/ms154040.aspx