Hi all,
First off, I'm fairly new to Jet Reports, so please bear with me, if I sound a bit noob'ish.
I'm thoroughly enjoying creating reports with Jet, though I have two questions (and yes, I have seen the light: I tried the search function first :lol: )
* My regional settings are Dutch(BE) - Period, thus, I need to have my office in the same language setting. However, I'm fairly used to working with office in English(US) and would like to keep it that way. Is there any prospect on getting an update/patch on this? My colleagues share this situation and it would greatly help us if we do no longer have to keep the regional settings in mind.
* Is there a way I can manipulate a macro, in order to have an autorefresh function? The general idea of what I'm trying to accomplish is to create a dashboard of sorts, that runs on a separate computer. This dashboard is naturally created in Jet Reports and would be running during work hours. Every, 10 or 20 seconds, it will refresh itself to show the most current data (as the data could be updated through updates through the web, internally, etc…). Any ideas? Refreshing the report usually doesn't take too long, so 10/20 seconds intervals hopefully do not stress the connection too much (I hope?).
Many thanks in advance!
Date
Votes
9 comments
-
Jet Reports Historic Posts No one that might have an idea? The first issue (concerning the MUI) is more pressing, but any feedback is greatly appreciated.
I'm guessing that it won't be able to do this through the Jet Reports VBA, since I simply have no business in that code. Maybe there was another way in Jet Reports to do this. Maybe something I can do in the scheduler…? -
Jet Reports Historic Posts To refresh the entire report have this line in a Macro.
Application.CalculateFullRebuildi'm not too sure on how to get it to run every 10-20 seconds -
Jet Reports Historic Posts Hi Bromy2004,
Many thanks for your input! Truth is, I had already tried this approach, but from what I can tell, it doesn't actually refresh the report like Jet Reports does. It does a standard worksheet refresh, but it doesn't fill the cache with newly generated data retrieved from the database.
So, What I'm trying to accomplish, is to have the refresh button from the Jet Reports ribbon, automized. -
Jet Reports Historic Posts I'm not familiar with makros at all, but here are my 2 cents…
If you have Auto+Hide+Report in Cell A1 Jet Reports will run automatically if you open the worksheet. Maybe this can be combined with a makro command? -
Jet Reports Historic Posts I didn't know about +Report.
Would it give you the options pop-up still? -
Jet Reports Historic Posts Yes, it will run a report as usual… the only difference is that it runs automatically when you open the workbook. Why don't you give it a try with one of your own workbooks ;)
-
Jet Reports Historic Posts Ive been told that +Report doesn't work in Jet 2009
-
Jet Reports Historic Posts Dang… you're right Bromy. It doesn't work in Jet 2009. Another nice feature they removed from the product :cry:
-
Jet Reports Historic Posts Just reporting back on this thread.
Regarding the refreshing, I have received a few helpful suggestions from the Jet Reports support team, which I've yet to fully test. Essentially, it involves tweaking the scheduler, through the windows scheduler, in such a manner, that Jet will refresh reports.
Regarding the MUI problem, the support team also swiftly replied that this would be a fixed in the new release.
The new release was in fact released very recently, so any multi user interface problems should be fixed since Jet Reports 1.9338.0.
Also, I'd like to congratulate Jet Reports, not only for the awesome product, but also for the swift and kind support. Awesomeness all around! A thanks to everyone else who pitched in. Much appreciated!
Please sign in to leave a comment.