I have a report that looks at an ODBC datasource, and relies on a date filter containing TODAY()-1 to retrieve rows from a table.
When I run this report manually, it shows me all the data I would expect to see, but when I run it from the scheduler, it does not update and still shows the values from the input file.
I have an identical report that looks for slightly different data, which was copied from the first, which also relies on TODAY()-1. This one runs fine from both the scheduler and when run manually.
Can anyone advise what kinds of things could be causing the first report to not refresh properly when run from the scheduler?
There are no named ranges in either report, and the tasks are setup the same. I am at a complete loss here.
Many thanks
Eds
Date
Votes
5 comments
-
Jet Reports Historic Posts You might want to check the Windows Task Scheduler (Control Panel | Administrative Tools) to see if the two tasks are running under different user accounts.
Since access to scheduled tasks is *VERY* tied to user permissions, this could play a role when the scheduled task attempt to run Excel. -
Jet Reports Historic Posts Thanks for the reply.
Both reports run under my account, and I am a domain admin, so shouldn't be any issues there.
It's as though the report runs with a TODAY()-1 value from the last time the input report was saved.
So as I run it monthly on the scheduler, it runs with last months date. If I run manually, save it, then the next run run will also use the month priors date. -
Jet Reports Historic Posts What I would suggest is that you contact Jet Reports Technical Support (https://support.jetreports.com).
What I'm guessing they will have you do is to enable logging (either for the task, overall, or both) and then allow the scheduled task to run - thus, creating the log files that they can review to see what issue is actually occurring during that task. -
Jet Reports Historic Posts Many thanks.
Will open a support case and see what they say :)
Eds -
Joanne Chong Check that the input report must be in design mode if there is no date in the option as filter.
Please sign in to leave a comment.