I am new to scheduling so I am trying to understand them and apply. I have for instance a report that has two prompts: one for FISCAL period (months that are different than calendar month) and Fiscal year (slightly different than calendar year as well). I need to run the report daily. SO far I don't know any other way than having multiple schedules defined for each fiscal month and set up a year at a time. The questions are: is it possible to have multiple schedules for the same report and how would I do this. And, is there a different way to set up the parameter's value in the prompts so that I would not have to create multiple schedules? Keep in mind that the period or month is defined different than the calendar month.
I think the biggest challenge I have with schedules is the parameters' values. But I would start with the example above to build experience.
Quote from: Amber12 on 18 Aug 2017 08:43:45 AM
I am new to scheduling so I am trying to understand them and apply. I have for instance a report that has two prompts: one for FISCAL period (months that are different than calendar month) and Fiscal year (slightly different than calendar year as well). I need to run the report daily. SO far I don't know any other way than having multiple schedules defined for each fiscal month and set up a year at a time. The questions are: is it possible to have multiple schedules for the same report and how would I do this. And, is there a different way to set up the parameter's value in the prompts so that I would not have to create multiple schedules? Keep in mind that the period or month is defined different than the calendar month.
I think the biggest challenge I have with schedules is the parameters' values. But I would start with the example above to build experience.
Hi,
What is the requirement here? Is it to run the same report and deliver outputs for different months? If so, have you considered bursting as an alternative?
MF.
Yes, that's what I have to do. I'm afraid I am not familiar with bursting. I remember hearing it during the training session but scheduling was barely touched. Now months later I need to know more.
I juts googled a little bit on Bursting the Report and when I looked into More - Modify Schedule, I don't see the bursting option. Is this something that the administrator would need to give me permission to do? Or where exactly would I find this bursting?
Quote from: Amber12 on 18 Aug 2017 09:00:14 AM
I juts googled a little bit on Bursting the Report and when I looked into More - Modify Schedule, I don't see the bursting option. Is this something that the administrator would need to give me permission to do? Or where exactly would I find this bursting?
Hi,
Bursting needs to be defined when authoring the report. Once this is part of the report spec, you should see the option to enable bursting when running the report in batch or when scheduling it.
Cheers!
MF.