We distribute lots of scheduled Jet reports in Excel format to staff on a regular basis. I would like to have a date as to when the report was run, i.e. when Jet queried the database. My simple Excel function, NOW(), gets reevaluated when the end user even opens the spreadsheet. To compound the issue, there are some staff who use Jetreports against these reports to tweak the parameters, so I need the date fairly dynamic. Some Excel suggestions on the web use a trigger of when the spreadsheet is saved. This causes a problem for those Jet users who tweak the report findings without saving the spreadsheet. Any suggestions as to some solutions? I could call a date from a database via a jet function, but I currently don't know where that might reside in our Serenic/Navision database. Maybe I'm not alone. Thanks!
Date
Votes
3 comments
-
Jet Reports Historic Posts I'm not completely understanding this…
If you have problems with the "Now()" because it gets reevaluated too often, have you looked in to "NP("Eval")"?
Please keep us posted,
Jan -
Jet Reports Historic Posts Jan,
So simple. Thanks! It works great. -
Jet Reports Historic Posts You're welcome.
Please sign in to leave a comment.