CODEWITHSUNDEEP
reporting-services
FistOfFury
FistOfFury

Reputation: 7155

Downloading SSRS Exports in bulk

I have an SSRS report that accepts a date parameter. I need to run this report for every month in the past two years and download in PDF format.

Is there a tool that can automatically pass in a parameter to SSRS and download the export?

Upvotes: 1

Views: 1777

Answers (1)

billinkc
billinkc

Reputation: 61249

Create your own tool or just manually build the links (it's only going to be 24 lines). By adding the parameter rs:Format with a value of PDF will instruct the reporting services engine to deliver the report in pdf format.

http://myrshost/ReportServer?/myreport&rs:Format=PDF

Here's a PowerShell approach Render SSRS Report with parameters using SOAP in Powershell Again, same concept except this has bits in there to save file as an output.

Upvotes: 3

Related Questions