Hello,
i have started the attached report but the runtime is already over 20 hours and i don't think that the Report will finish successfully!
In that Report i have a lot of sum functions on the value entries implemented. The Report should have the following structure:
1) Salespers./Purch. Code (all active salesperson in NAV) with Sales Amount
2) Item Type (new flow field in value entry table) with Sales Amount
3) Customer No. (all customers with sales in the time period) with Sales Amount
All Rows should be sorting by descending Sales Amount. Further i calculate the Sales Invoice Lines and Sales Cr.Memo Line in the last 4 lines.
Is it possible to design that kind of Report with Jet?
Thank you in advance.
Regards
Daniel
Date
Votes
1 comment
-
Jet Reports Historic Posts It is absolutely possible to create a report as you describe.
There are two aspects you mention that do create challenges. #1: working with the the Value Entry table (the single largest table in a NAV database) and #1, sorting.
Sorting can involve examining each and every entry in a table. Sorting by a sum additionally involves adding up a lot of numbers.
Combining those aspects (i.e., sorting entries in the Value Entry table) can mean that Excel has to perform a large number of calculations. This, of course, can equate to a large amount of time.
If there is anything you can do to mitigate by either getting data from an alternate table or not sorting, this can improve the performance of any set of calculations.
Please sign in to leave a comment.