Oleg Oleg - 3 months ago 6
SQL Question

how to automatically save fresh SSRS report on a hard drive daily

I have subscribed SSRS report that is executed on a daily basis. But I also want the copy of that report automatically saved in a folder on a local machine with slightly changed name of the report.
So one copy goes to the user, the other copy goes to the hard drive.
Is that possible to achieve that?

Answer

If you have the Enterprise Edition, you can use a data-driven subscription that uses a query to populate the report name.

You would have a query as the source with a field for the report name:

SELECT 'Report Name ' + CONVERT(VARCHAR(8), GETDATE(), 112) AS REPORT_NAME, ...

https://msdn.microsoft.com/en-us/library/ms159150(v=sql.110).aspx

Comments