Search code examples
reporting-services

SSRS URL to export to Excel Automatically

I have a report that is hosted on SharePoint. Is it possible to have the report automatically export the results into Excel? I tried the following url:

http://someServerName/_layouts/15/ReportServer/RSViewerPage.aspx?rv:RelativeReportUrl=/Reports/Balance%20Sheet.rdl&rp:DateRange=Last Month&rs:Format=EXCEL

but it just automacially populates the parameter and executes the report. Wonder if it couldn't just automatically export it.

Also, does anyone know of a resource that shows t-sql code that will create a subscription for a report that is hosted on SharePoint?

Thank you.

Solution

  • I don't think you can use the RSViewerPage.aspx for a download link. We use the direct link to the reportserver from Sharepoint.

    http://someServerName/ReportServer?/Reports/Balance%20Sheet&rp:DateRange=Last Month&rs:Format=EXCEL