Hi Peoples,
Is it possible to show the Report Run time in Jet.
i have some reports on a Schedule that would be better if i could see how long it took to run them.
Date
Votes
4 comments
-
Jet Reports Historic Posts You can see the report runtime at the bottom of the screen afer running a Jet report, but this actually doesn't seem very helpful for your situation. I can't think of a good way to do this so I'm going to collect it as a feature request.
-
Jet Reports Historic Posts I have been thinking about this before…
Isn't it possible for JetReports with a scheduled report to create a custom document property. See screenshot -
Jet Reports Historic Posts I've done this before and yes it breaks one of the rules for creating reports by having a =Now() function without an NP("Eval") around it.
First, make sure that you are using Auto+Hide+Values in cell A1. This will not work without this.
A1 Auto+Hide+Values
C3 =NP("Eval","=Now()")
C4 =Now()
C5 =NP("Format",C4-C3,"h:mm:ss")
However, I found a problem with this when using Jet Reports 2009. The NP("Format") function isn't working correctly (and yes, I've told Jet Reports, so hopefully it will be fixed soon). However, you can change cell C5 to
=NP("Union",C4-C3)
and Format Cells C3, C4, C5 as a Time field. I use the format of h:mm:ss
Be sure to let us know if this works. I find the results of this to be just a few seconds off from how long it really takes, and I suppose that would depend on the computer you are running it on, but it does seem to work for me. -
Jet Reports Historic Posts Hi,
i have Tested it and the problem that came up was when the report was opened the =now() function re-calculated.
would it work if i put a =NP("Eval","=NOw()") at the very start of the Options Sheet and another at the very end of the last page?
Please sign in to leave a comment.