October 2, 2015 at 12:48 pm
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?
October 2, 2015 at 5:21 pm
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);October 5, 2015 at 9:52 am
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
October 6, 2015 at 12:08 pm
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.
October 6, 2015 at 3:30 pm
October 6, 2015 at 3:35 pm
I did, but as stated above that only gave me a listing of links to the reports on the report server.
October 6, 2015 at 4:19 pm
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.
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply