Report not showing new data when run from schedule, but works fine manually

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


Please sign in to leave a comment.