Being able to enter report options with Database Lookup, using NL("Lookup",…) rather than directly onto a separate "Options" worksheet, makes our reports much easier to use.
However, when run unattended with Autopilot, such reports will wait indefinitely for user input that never arrives.
For many reports, I now have two versions, one for interactive use and another for use with Autopilot.
Is there a way to detect at run-time if the report is running under Autopilot? I then could use a formula like =IF(RunningUnderAutopilot(), "", "Option") in the first column of my "Options" sheet. This would enable me to use the same report both interactively and with Autopilot.
I could of course define a named cell "running_under_autopilot" and set this to some value with Autopilot, and this would work, but the resulting report would keep the value of "running_under_autopilot" and hence skip the options dialog when re-run interacively by an end user.
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Hans,
Are you sure, the reports are taking forever to run with report options? In face, Jet does detect whether you are running under AutoPilot and should never display the report options when this is the case, so they should run just fine. If this is not the case, you should either upgrade Jet to the latest version (there may have been a version a long time ago with a bug that caused this) or file a support ticket on the Jet support site. Your reports with report options should run just fine in AutoPilot.
Regards,
Hughes -
Jet Reports Historic Posts I'm using Jet Reports 2010, which always displays the options dialog and waits (of course only when there is a NL("Option"…) formula with the right headers) even when running under Autopilot.
I'll try upgrading to the newest Jet version, and also look whether running while logged out makes any difference (the PowerShell script that calls Autopilot doesn't work yet when logged out, which is certainly my fault)
When all of this doesn't help, I'll file a support ticket.
Thanks for your help!
Hans
Please sign in to leave a comment.