Auto-refreshing jet reports

Questions and Answers asked by users to users, about how others use Jet Express.

Auto-refreshing jet reports

Postby Marta » Fri Jan 06, 2017 1:08 am

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
Marta
 
Posts: 1
Joined: Fri Jan 06, 2017 1:00 am

Re: Auto-refreshing jet reports

Postby HPDeskJet » Fri Jan 06, 2017 7:13 am

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!
HPDeskJet
 
Posts: 171
Joined: Tue Sep 06, 2011 9:20 am


Return to Ask the Community

Who is online

Users browsing this forum: No registered users and 3 guests