Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

Export data into the xls Sheet Directly without click on the View Report. Expand / Collapse
Author
Message
Posted Thursday, October 9, 2008 5:49 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, November 6, 2012 1:35 AM
Points: 6, 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
Post #583217
Posted Friday, October 10, 2008 10:00 AM


SSC-Addicted

SSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-AddictedSSC-Addicted

Group: General Forum Members
Last Login: Tuesday, October 28, 2014 8:09 AM
Points: 452, Visits: 483
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...
Post #584093
Posted Tuesday, October 14, 2008 5:14 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, August 12, 2014 8:01 AM
Points: 230, Visits: 261
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.


Post #585356
Posted Tuesday, October 14, 2008 12:42 PM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, May 13, 2009 1:16 PM
Points: 38, 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 .



Post #585721
Posted Tuesday, January 28, 2014 4:40 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Friday, July 25, 2014 10:30 AM
Points: 1, Visits: 45
I tried by putting that code but still facing an issue. can you please provide steps in details/
Post #1535378
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse