I am trying to use the scheduler for the first time. In the advanced tab, I would like to use the "update report options" part to edit the date range option in my report. I need to schedule a daily report that will show results from the previous day.
First, how do I add the option I want to edit to the filter in scheduler. When I try to click on the filter cell, I see a msg: double click a row to edit the value or change the update status. What row am I suppose to click?
Once I figure out how to put an option in the filter box, what can I enter for the previous day's results? t-1 or (TODAY)-1
Any help would be appreciated!
Date
Votes
4 comments
-
Jet Reports Historic Posts Official comment Hi,
When I go to Schedule and create a new scheduled task for your report, I can see both the LocationCode and PostingDate named ranges and set filter values for them. I'm not sure exactly what steps you are using where you're not seeing this. What version of Jet Reports are you using and what are the steps you're going through where you're not seeing the options?
Regards,
Hughes -
Jet Reports Historic Posts Create a Named Range on cell D5 for example "PostingDate".
Do this by clicking next to the formula bar where D5 is written and type "PostingDate" and finish with ENTER.
Now that report option will be available.
Better is that when the report always runs with yesterdays date to enter NP("Eval","=TODAY() - 1") as formula of D5.
Make sure the cell IS NOT formatted as TEXT. -
-
Jet Reports Historic Posts I somehow cleared my formulas when I was editing it. It seems to be working now. I will know for sure tomorrow when it produces the first scheduled report. Thanks!
Please sign in to leave a comment.