ReportServer Forum

hlynch

Member

Registered: 2014-10-08

Scheduling reports question

Would it be possible to schedule a report from a script, that would be emailed to a specified email address(s)?
Then would it be possible to run that script via URL, where the report parameters would be passed in on the URL?

If this is possible, any example script code available to teach how?

hlynch

Member

Registered: 2014-10-08

Re: Scheduling reports question

Just in case, By Schedule I mean setup for a report to run at a time in the future. Not immediately.

eduardo

Administrator

Registered: 2016-11-01

Website

Re: Scheduling reports question

Hi hlynch,

for scheduling a report from a script to email, you can use either SendTo: https://reportserver.net/en/guides/scri … s/Send-To/ or, better: script datasinks: https://reportserver.net/en/guides/scri … Datasinks/
Both support scheduling, so you have the standard scheduler functionality from RS.

For running reports from URL: https://reportserver.net/en/guides/admi … a-the-URL/
For running scripts from URL: https://reportserver.net/en/guides/scri … rs/Basics/ (3.2. Executing Scripts via URL)

So you can write a script that is callable from an URL, passing any parameters necessary. This script may execute your report and send it via SendTo or via script datasink (or via a simple email datasink https://reportserver.net/en/guides/admi … Datasinks/ ) to the Email address(s).
If you don't want to send it immediately, as you say, you can also schedule execution e.g.: https://github.com/infofabrik/reportser … ler.groovy

Regards,
Eduardo