Hi all,
I'm having troubles making a report concerning the performance of Jet.
We would like to make a report that shows us the turnover (Sum) from the Sales Invoice Line per Vehicle. First of all we filter our Sum function on posting date to get the information per month. Secondly to receive the amounts per vehicle code we have to make a link from the Sales Invoice Line to the File table (File No. is the common field) because there we can find our Vehicle code back.
The problem is that our File table has a lot of data in it. So our link to the File table slows down our report. Report Run time = > 4 minutes = way to long…
Here's my formula:
=NL("Sum";"Sales Invoice Line";"Amount";"Posting Date";H$6;"Link=";"File Tpt";"File No.";"=File No.";"Vehicle";$E9)
Any idea how we can improve the performance of this formula?
Thanks,
Bert
Date
Votes
2 comments
-
Jet Reports Historic Posts Hi Bert,
You could create a flow field in NAV on the Sales Invoice Line table which pulled the vehicle from the File Tpt table. This would probably make your function quite a bit faster because in your report you could just filter by the vehicle right on the Sales Invoice Line table rather than using a link.
Seriously, though, I have seen many reports that take multiple hours to run, so 4 minutes is not that long. If you don't like waiting for it to run, maybe you could use the Jet Scheduler to run it on a schedule. Then you would have the results at whatever time you needed them.
Regards,
Hughes -
Jet Reports Historic Posts Hi Hughes,
I can understand that several reports need a long time to run, but this is a report that a user wants to run and where he want's to get an "immediate" result. Not something where he has to wait for longer than 4 minutes…
Performance of Jet is most of the time better than running a report out of NAV, but the advantage of NAV is that you see your report faster than in Jet…
Regards,
Bert
Please sign in to leave a comment.