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

  • 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

  • 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...

  • 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.

  • 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 .

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

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

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