#1 2021-07-12 14:42:53

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

Offline

#2 2021-07-13 10:46:13

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

Offline

#3 2021-07-13 14:06:10

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?

Offline

#4 2021-07-14 15:52:43

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.

Offline

#5 2021-07-29 07:57:10

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

Offline

Board footer

Powered by FluxBB