How can I make this report better? It takes forever to run even when i use a small data range.
Any asssitance would be appreciated.
Jeremy
Date
Votes
4 comments
-
Jet Reports Historic Posts Hi Jeremy,
When you say "forever", what do you mean? I find that different peoples' perceptions of what a long time is are quite different. In the context of Jet Reports, I've heard someone say that 10 minutes is too long and someone else say that 3 hours was reasonable.
It looks like you're replicating a lot of data here. How many rows of data on each sheet are you getting on average? There is an optimization for replicating large data sets with lots of NF functions in the latest version of Jet Reports 2010 R2 that could potentially speed up your report quite a bit so you might try upgrading to that version of Jet.
If there are NF functions to some fields that you may not need to see, I would suggest eliminating those. You could also split the companies out and create a different version of the report for each company (or make the company a report option) so you were only running the report for the specific company you wanted to see. Another option would be to use the Jet Scheduler and schedule the report to run overnight.
Regards,
Hughes -
Jet Reports Historic Posts Thanks for the reply,
The report runs within two minutes for 2 months of data(chaning the range), then 15 minutes for 3 months of data, and at 4 months it's still running after 1 hour 30 minutes. I'm just not sure if it's a formula issue or data issue. I have revised the report to only pull from the Purchase tables as oppose to the Purchase Archive tables. The issue with this is I don't get closed PO information. As I was reviewing the records for Purchase Archive lines there are mutliple lines for one item. I was not sure how to sort out the last line, because the NL first/last record would not return the last entry. As I've gone in circle, the basic need for the report is to populate PO header Line info for qty/cost whether closed or open.
The system gives me an error when I try to schedule. Something about batch permissions. -
Jet Reports Historic Posts Actually it's strange. I heard that the report running should not take that much time. Are you sure everything's OK with your settings? Cuz I now even dunno what to advise.
_______________
http://freearchiver.net/ -
Jet Reports Historic Posts Do you have the NF Function Optimization option turned on in your Jet Application Settings on the Advanced page? You have a lot of NF functions in this report and that might help.
Regards,
Hughes
Please sign in to leave a comment.