topic Re: Automating export/download of Linked Report in Report Server

Automating export/download of Linked Report

mewisenb — Tue, 12 Jan 2021 19:25:33 GMT

Is it possible to automate downloading/exporting a Linked Report as a regular user? I've been futzing around with the SSRS powershell module, but have not made much headway.

Re: Automating export/download of Linked Report

d_gosbell — Tue, 12 Jan 2021 23:54:14 GMT

If the original report uses data sources with stored credentials you should be able to setup a report subscription to output the report to a file on a scheduled basis. But if the report uses windows authentication this is not possible.

If you wanted to use powershell you could use url access to get an export of the report see https://docs.microsoft.com/en-us/sql/reporting-services/export-a-report-using-url-access?view=sql-server-ver15

So you could use something like the following:

Invoke-WebRequest -Uri "http://localhost/reportserver?/Demo%20Reports/Products%20by%20Colour&ProductColor=Black&rs:Format=EXCELOPENXML" -OutFile "c:\temp\report.xlsx" -UseDefaultCredentials

I ran this on my local dev server and it exports the "Products by Colour" report with a parameter value of "Black" and outputs the results to an excel file.

Re: Automating export/download of Linked Report

mewisenb — Wed, 13 Jan 2021 18:33:16 GMT

d_gosbell,

This worked a treat! I really do appreciate your help. For whatever reason we don't have the permissions to create subscriptions.