SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


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


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

Author
Message
Kali Charan Tripathi
Kali Charan Tripathi
Grasshopper
Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)Grasshopper (14 reputation)

Group: General Forum Members
Points: 14 Visits: 281
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
Alasdair Thomson
Alasdair Thomson
Mr or Mrs. 500
Mr or Mrs. 500 (562 reputation)Mr or Mrs. 500 (562 reputation)Mr or Mrs. 500 (562 reputation)Mr or Mrs. 500 (562 reputation)Mr or Mrs. 500 (562 reputation)Mr or Mrs. 500 (562 reputation)Mr or Mrs. 500 (562 reputation)Mr or Mrs. 500 (562 reputation)

Group: General Forum Members
Points: 562 Visits: 506
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
maxeverest@googlemail.com
SSC Veteran
SSC Veteran (246 reputation)SSC Veteran (246 reputation)SSC Veteran (246 reputation)SSC Veteran (246 reputation)SSC Veteran (246 reputation)SSC Veteran (246 reputation)SSC Veteran (246 reputation)SSC Veteran (246 reputation)

Group: General Forum Members
Points: 246 Visits: 299
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
Robert Edgson
SSC Rookie
SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)SSC Rookie (44 reputation)

Group: General Forum Members
Points: 44 Visits: 26
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
amit patil-232134
Forum Newbie
Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)Forum Newbie (7 reputation)

Group: General Forum Members
Points: 7 Visits: 45
I tried by putting that code but still facing an issue. can you please provide steps in details/
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search