ReportServer Forum

unsi_2

Member

Registered: 2020-06-24

script for creating variants / schedules of a report

hi

We want to create different executions (1000) of a report, with different parameters values each, and send them via mail every day.

We want to track the schedules.

Our question is, can the different variants and the schedules be created dynamically via a script or so?

kind regards

jalbrecht

Administrator

Registered: 2016-10-21

Re: script for creating variants / schedules of a report

Dear unsi_2,

the answer is yes. Pls. check https://reportserver.net/en/guides/scri … pt-Reports and subsequent pages for further details. You might as well be interested in https://reportserver.net/en/guides/scri … g-Scripts/ or in https://reportserver.net/en/guides/admi … a-the-URL/.

happy scripting !
jan

unsi_2

Member

Registered: 2020-06-24

Re: script for creating variants / schedules of a report

thanks, do you have a sample script where the different variants and the schedules can be created dynamically?

aditi.raiter

Member

Registered: 2018-05-01

Re: script for creating variants / schedules of a report

The sample groovy scripts on the forum have a send to email API that can be scheduled with scheduleScript execute groovy script. With that we loose visibility in the scheduling tab. Is there a way to call the scheduler API instead from a groovy script.

Mario

Banned

Registered: 2021-06-24

Re: script for creating variants / schedules of a report

Dear aditi_raiter,

what you probably need is an example script for scheduling via the API. We developed a scheduling script for that very issue that you can find here.

If you need any further assistance just ask us here. We will be glad to help you.

Regards,
Mario