I need to go back to Jet 101 and ask why my dates aren't being saved.
I'm using NAV 5.1 and just upgraded to Jet 2009. I have office 2007 and 2003.
On my options tab of my daily, automated report(s) I have the =NP("Eval","=TODAY()-1")formula in $F$2 to the right of my Value column and the Value cell $E$2 formula is =F2 to reference the NP formula. When I run and save the report, the next time I open the report, the $E$2 cell is now the saved value from the original run. Every day my report runs for the same day, the original save date instead of advancing to the next day.
Title Value
Date 12/27/09 12/27/09
This problem is new to Jet 2009 and I thought I saw a different way to save the dates on the option tab, but I can't remember what to search for on the community site.
Thanks for your help!
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Jet Reports support went to my spam box. After retreiving their 12/30 response TODAY, I received a response with a working solution. Here is the response from Jet Reports.
OK David, I see what's going on. The reason it overwrites your date function is because you are using the Report Options feature (That's the Title, Value, and Option Keywords). Each time you run the report, it will overwrite whatever is in the Value column, that's just the way the Report Options works. There are a couple of things you can do to fix this.
One solution is to simply delete the Report Options keywords from the Options page. The only drawback is that when you run the report manually, it will no longer pop up an options screen for you, so you'll have to unhide the options page if you want to be able to set the options from report mode.
The other solution can be done within the Scheduler (you did say you are running this report with the scheduler, right?). First you'll need to make cell E2 a named range (click the cell and then press CTRL+ALT+F3 to define a name). Then, in the scheduled task, on the "Options" tab, you should see the named range appear. In the "Filter" column of the Options tab, type in the formula that you wish to substitute into that cell, =TODAY()-1, and check the "Update" box. The scheduler will then put the formula into that cell before the report runs each time. -
Jet Reports Historic Posts I've looked at some of my reports that are still running properly and found that I simply used =TODAY()-1 on my Options page.
But when I use =TODAY()-1 now (Jet 2009) it saves the date, not the formula.
I'm sure the answer is in Help, but I don't know what to search for to find it.
Please sign in to leave a comment.