Hi all,
yesterday I created quite a number of scheduled tasks, which run a report with different date and location filters. I have created named ranges for these fields and had them as options when I created the tasks yesterday. For testing purposes I let each task run one time and the output was alright. Today I wanted to have a look at them once more and had to discover, that the options in scheduler have disappeared for every task :shock:
I suppose I have to recreate them, but before I do so, I would very much like to know the reason for this in order to avoid it next time…
Thanks and kind regards,
Maja
Date
Votes
5 comments
-
Jet Reports Historic Posts Hello Maja,
did you create your ranges with the "$"-sign, or without?
regards
jetsetter -
Jet Reports Historic Posts Hi Jetsetter,
I created a start and an end date with the Excel functions TODAY(), MONTHEND(F6;-2)+1 and MONTHEND(F6;-1). These fields are referenced by the option field "Date" via NP("DateFilter";$G$6;$H$6).
Kind regards,
Maja -
Jet Reports Historic Posts hi,
does it work when you change
"MONTHEND(F6;-2)+1 and MONTHEND(F6;-1)"
into
MONTHEND($F$6;-2)+1 and MONTHEND($F$6;-1)" ?
regards -
Jet Reports Historic Posts Hi Jetsetter,
I am such an idiot :oops: The reason was: I moved the template for the reports to another folder, but forgot to change the input parameter in the scheduler as well… When I do so, everything is working as expected.
Nevertheless thank you very much for your answer!
Kind regards,
Maja -
Jet Reports Historic Posts ;)
good to hear, that other people make the same mistakes i did :D
regards
jetsetter
Please sign in to leave a comment.