Hi,
I've build a Jet Reports to make a dashboard to analyze the revenues generated by our company.
This report runs fine from January up to August. But from September on I'm getting errors that Excel/Jet Reports could not retrieve a formula from a range. While our revenues increase with each month I was thinking that the list was just to long so I tried splitting it up on several worksheets within the workbook. The splitting works, so the list is shorter and if I run the Jet Reports with only those sheets and the dashboard sheet not included (so basically just for worksheets with Jet functions to create lists) it all works fine.
But if I put in the worksheet with the dashboard again I get the same error only with a smaller range (for instance it used to be range $A$1:$M$24000, now it is $A$1:$M$17594).
Has anyone any idea on what causes this error? I'm using SUM.IF functions to summarize the data on the "list" worksheets on the dashboard. I tried using an NL("SUM") function, but that just exploded the run time of the report from approximately 10 minutes to over an hour.
I have a screenshot of the error attached, although I should mention that the error is in Dutch.
Thank you very much for the help.
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi,
i get the same error (in German ;) ) when i run a Report, which needs a lot of memory….
In most cases, after a restart or after using less data (filtering), it runs without the message.
Normally the values and data in the Report after the message are OK, but you can't save the file as "Value".
regards
jetsetter -
Jet Reports Historic Posts Same here.
It seems a memory issue.
Less data and all works fine.
Strange thing is when I save the report and do a copy/paste as values, I am able to convert the report to values.
But then ALL the formula's are gone, not only the JetReport formula's
rmw
Please sign in to leave a comment.