hi everybody.
I come here again with one more problem i am having… thanks for your time!
I am preparing a stock report and it has 4 different levels and it totalize quantities and amounts in each one:
Qty. |Rsv Qty|Available Qty|Unit Cost|Amount|Unit cost Avail|Amount Available|
F 10 CELL –> Warehouse
f11 CELL —> ITEM CATEGORY
f12 CELL –> ITEM
f13 cell –> Lot No.
For each of this level I want to calculate Qty, Reservd Qty, Unit cost, Amount…
I have formulated it with NL SUM function nearly all but in order to optimize it I want to use Nl sum function just to calculate results for LOTS (batch) and to calculate the other levels with =SUM function directly from Excel and not using jetreports function.
I know that for doing this I have to create -and hide-, more columns but i am a bit lost with the number i have to use in each NL(ROWS=???) at the beggining of each level to calculate ok this SUMs.
Can anyone help me with this? Thank you so much again!!
Date
Votes
2 comments
-
Jet Reports Historic Posts Official comment Hi Nacho,
Actually you are much better off using NL(Sum) to get your totals than replicating more data and hiding it. The optimized way to do this is the way you're already doing it. I wouldn't recommend trying to replicate out the data and use Excel SUM functions to do this. If you want your report to run faster, you could add keys in Navision with the fields you're filtering by and add SumIndexes to those keys for the fields you're summing.
Regards,
Hughes -
Please sign in to leave a comment.