Is there a way to print the report run time on the report?
Date
Votes
5 comments
-
Jet Reports Historic Posts Nope, currently there is no way to do this. You can see the report runtime in the Excel status bar (bottom left corner of the screen) after running a report, but this is not preserved when you save and close the workbook. Is there a particular reason you want to print the runtime in the report?
Regards,
Hughes -
Jet Reports Historic Posts I want to be able to show that certain reports take a long time to run. Then I can analyze & see whether it's keys or certain filters that affect it.
-
Jet Reports Historic Posts I suppose you could fairly easily write a VBA macro to do it, although it wouldn't be supported by Jet Reports. You would just have to take note of the current time in your macro, then call the macro to run the report:
Application.Run "JetMenu", "Report"
Then take note of the time again, do some subtraction and write the result to a cell. Like I said, macros aren't supported by Jet Reports, but this one would be fairly easy to write.
Regards,
Hughes -
Jet Reports Historic Posts This may not be what you are lookoing for but schedule the report to run on its own - scheduler will tell you when it started - look at the time it was created in the output folder and thats when it completed
This only works if you schedule single worksheet in the task but it will get you the info it sounds like you want ( how long it took to run the report) -
Jet Reports Historic Posts What about a first sheet in your workbook with only the function NP("Eval","=NOW()") and a last sheet with the same function?
You should be able to retrieve both values and subtract them, I think….
Just thinking out loud :)
rmw
Please sign in to leave a comment.