Hi,
I wanted to have jet report driven spreadsheet open on the screen for view, but also to autorefresh itself every 5 mins so that latest data will be displayed, is that possible? I tried to set this up through the Scheduler and Windows Task Scheduler but the report is not refreshing.
Any suggestions?
Thanks
1 comment
-
Jet Reports Historic Posts Hi Marta -
The scheduling capability of Jet Professional can refresh a report and save the results to a file. This would not result in refreshing a report that is already displayed onscreen. Additionally, Jet Express does not have scheduling.
However, there is an option that may get you where you need to be.
Although Jet Reports does not support macro-enabled workbooks, some of the Jet features are accessible through VBA (Visual Basic for Applications). Thus, if you are familiar with VBA, it would be possible to write a macro that refreshes your report every 5 minutes.
More information on automatically refreshing a report can be found in the Jet Reports online knowledgebase –> https://jetsupport.jetreports.com/hc/en … /219403087
Good luck and have fun!