This report uses a navision 3rd party add on for collections it runs by division and branch and takes about 6 hours to run from Day one to today as parameter
report works and returns the right data I'm just curious if anyone has a bright idea on anything I can do to the report to reduce the run time .
In my long years of doing this kind of stuff I discovered that somedays the longer you look at somethung the less of the obviosu you see
Thanks
Date
Votes
1 comment
-
Jet Reports Historic Posts Hi Van,
I know that you posted this a really long time ago but I can see some places for improvements. They might come in handy in your future reports as well. The first thing I noticed is that you have cell references linked directly to the "Home Page". These cross-sheet references can really slow Excel down especially with as many worksheets as you have in this workbook. Using NP(Eval) functions will really help to speed things up. I also noticed that you are using an NL(Filter) to filter your customers by information in the CLE table. You may want to consider using Link= instead of NL(Filter). I have found that when you are going from a smaller table (Customer) to a larger table (CLE), Link= is usually faster.
Anyway, I hope these suggestions help.
Please sign in to leave a comment.