Home Forums Reporting Services Reporting Services 2005 Development Export data into the xls Sheet Directly without click on the View Report. RE: Export data into the xls Sheet Directly without click on the View Report.

  • October 14, 2008 at 5:14 am

    #884533

    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.