I have reports scheduled to run once a week for our school principals. I am changing over from our 2016-17 year to 2017-18 year. I changed the date on my reports but the 2016-17 year continues to be sent out. When I run the reports locally they run correctly
3 comments
-
Harry Lewis Hello Rod -
There are a few things to consider. I'll assume that you are using the Jet Scheduler in the Jet Excel add-in.
Is your scheduled task configured to pass in a date? If so, is that the date you changed?
-
Rod Steeves Hi Harry:
I am not sure where I would find what you are referring to. I have changed the date filter reference on the report but I was unaware of another date reference.
-
Harry Lewis Hi Rod -
Within an Excel workbook, it is possible to have named cells:
From within the Jet Scheduler, you can update such cells to specific data:
If your scheduled task is configured to set the date, changing the date only in the report would have no impact.
If your issue goes deeper that this, you will probably want to submit a support request so that you can send in your report and details about the scheduled task: