How to Export SSRS report into Excel format using query string
Hello all, I am new to SSRS world. Last night i was trying to add a hyperlink on the SSRS report (.rdl) file, by clicking which we can export the report into "Excel" format, but with no luck. Can anybody tell me how to form the hyperlink, so that we can export the report with its current content ( I mean the report content generated by selecting some parameter values)
April 30th, 2010 9:20am

Hi, what you are trying to do using some kind of hyperlink is actually available right out of the box by SSRS ! The rendering engine support export to excel (just as to word, pdf, etc. These exports take the current content of the report. Good luck with SSRS, it's a nice product for corporate reporting Regards, Vulcan900
Free Windows Admin Tool Kit Click here and download it now
April 30th, 2010 3:58pm

Yos can use this url in report which will export it to excel. http://Server/ReportServer?/Foldername/ReportName&rs:Format=excel You have to use TextBox. Then got to textbox properties. And In Action tab select Go to URL And Expression given below for Select URL. =Globals!ReportServerUrl & "?" & Globals!ReportFolder & "/" & Globals!ReportName & "&rs:Format=excel" Thanks KishanMark it as Answer if this post helped you.
April 30th, 2010 4:20pm

Vulcan900 is correct. This comes right out of the box with SSRS. If you create a link to do this then you are actually doing twice the amount of work needed on the server as it would have to reprocess the dataset and re-render the report. Check this link out: http://msdn.microsoft.com/en-us/library/ms157153.aspx Hope this helps, --JoshJosh George LiveLogic, LLC
Free Windows Admin Tool Kit Click here and download it now
April 30th, 2010 6:26pm

I was just giving the example. You can use same expression in other report you just have to replace Globals!ReportFolder and Globals!ReportName with some other folder and report in report server.Mark it as Answer if this post helped you.
April 30th, 2010 6:45pm

Hi Josh and Vulcan In this case, i don't want to leverage on SSRS's out of box, as we are going to place the report in sharepoint's ReportViewer web part. We don't even has to use the ToolBar of ReportViewer web part which is used to export the report, as per my requirements. So the only alternative i left with is URL access as mentioned by Kishan , which is working fine as of now. Any better alternative, is highly appreciated. Thanks Suman Kumar
Free Windows Admin Tool Kit Click here and download it now
May 5th, 2010 10:29am

Hi Suman85, Based on your scenario, you want to add a link on the SSRS report file, and then click it you can export the report into “Excel” format. Just as kishan1901 said , you can add a textbox to your report and type in the words “Click here and export the report to excel” .Then right-click the textbox and select Properties. Switch to Navigation tab, click the radiobutton of ‘Jump to URL’ and type in the expression ,here is just a example: ="http://vyof1884200/ReportServer$youhoo?/My+Adventure+Works/Product+Sales+and+Profitability+by+Month&rs:Command=Render&rs:Format=excel" Then preview the report ,you will see Click here and export the report to excel when you move the mouse to it ,the mouse will become a hand ,then left-click, it will jump out a dialog box to indicate user whether the excel file should be saved , opened or canceled. I think this is what you want, if you have any further requirement, could you please describe it in more detail? We would give you some resolution or workaround. Regards, Challen Foo
May 5th, 2010 12:15pm

Hi Challen, In my case I have parameters in my reports, so how do I achieve that because it will ask me for the parameter values Please help urgentlyCRM Manager
Free Windows Admin Tool Kit Click here and download it now
March 30th, 2011 11:58am

Hi, You can add the user parameters in the same url =Globals!ReportServerUrl &"?" & Globals!ReportFolder & "/" & Globals!ReportName & "rs:Command=Render&rs:Format=excel" & <Parameters> for example =Globals!ReportServerUrl &"?" & Globals!ReportFolder & "/" & Globals!ReportName & "rs:Command=Render&rs:Format=excel&Year=2010" or =Globals!ReportServerUrl &"?" & Globals!ReportFolder & "/" & Globals!ReportName & "rs:Command=Render&rs:Format=excel &Year = " & Parameters!Year.Value -Vijay
April 8th, 2011 2:47am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics