Export data into the xls Sheet Directly without click on the View Report.

Question

Export data into the xls Sheet Directly without click on the View Report.

Kali Charan Tripathi

SSC-Addicted

Points: 404
More actions
October 9, 2008 at 5:49 am

#194423

Hi All,
I am trying To Create a Button On the SSRS 2005 Report by which user can Export data into the xls Sheet Directly without click on the View Report.
Would appreciate if some one can come out with a solution for the issue or is there any option in SQL Server 2005 for the can Export data into the xls Sheet Directly without click on the View Report
Thank You In Advanced.
Kali Charan Tripathi
INDIA
Mail ID -- tripathi_soft@yahoo.co.in
-- kalicharan.tripathi@in.schneider-electric.com

Viewing 5 posts - 1 through 4 (of 4 total)

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

Alasdair Thomson Hall of Fame Points: 3630 More actions · Answer 1

You can't in short, not unless you set up a subscription to a report selecting xls as the output format and have it either email a user or email them automatically. I believe subscriptions are only available on Standard and above...

maxeverest@googlemail.com Old Hand Points: 332 More actions · Answer 2

I have been faced with a similar problem and by using passing &rs:Format=EXCEL it will automatically render a report to excel, i.e.

http://localhost/ReportServer/Pages/ReportViewer.aspx?%2Reports%2fDailyReport&rs:Command=Render&rs:Format=EXCEL

If you wanted to have the fuinctionality embedded into a report you would just set the relevant field to have the above as a navigation url link. If you wanted to pass a parameter you can use the example below:

="http://localhost/ReportServer/Pages/ReportViewer.aspx?%2fTest%2fReport3&PARAM=" & Fields!ID.Value & "&rs:Command=Render&rs:Format=EXCEL"

This is placed in the navigation properties of the specific ID field that I want passed to the second report.

I hope this helps.

Robert Edgson SSC Journeyman Points: 88 More actions · Answer 3

The word "button" implies you want more of your own web site. SSRS does not allow the addition of buttons it is simply not in the tool bar.

If you want greater functionality than the standard graphical you can write you own web site and then add a web reference to SSRS ReportExecution2005 ie. http://localhost/reportserver/ReportExecution2005.asmx

This then allows you to call the full range of methods including the render method

This might cross the boundary from SSRS developer to web developer.

But the flexibility is there .

amit patil-232134 SSC Journeyman Points: 93 More actions · Answer 4

I tried by putting that code but still facing an issue. can you please provide steps in details/