Hello,
I would appreciate your recommendation on the following issue.
I have a huge report, with hundreds of Jet formulas, around 10 various sheets, and a large database in NAV. It takes like 30 minutes to run.
When I open the report (previously saved in Report mode) on a computer that has Jet installed it starts calculating formulas and it takes a very long time for the report just to open so it can be read.
Do you have a hint?
Thanks,
Elena
Date
Votes
3 comments
-
Jet Reports Historic Posts if you want a report to remain in "Report Mode" with all values kept at the time of the report run - you need to add +Values to the Auto+Hide command in cell A1, this will keep any Jet Report formulas to keep from updating.
if you're wanting the values to refresh each time the report is opened, then you need to see if any of your formulas can be changed to speed up the report. -
Jet Reports Historic Posts On each of my sheets I have places Auto+Hide+Values.
But still, when it opens I have the ”Calculating” window… -
Jet Reports Historic Posts very odd - any time I've had this happen in a report, I found at least one sheet that did not have +VALUES for the worksheet key
this may be a support issue if no one else has any suggestions
Please sign in to leave a comment.