Adding a total to a NAV report

wml · 2017-01-23

Hi,

I am currently editing a Packing List report in the NAV development environment (with report builder). The last thing I need to do is to add several totals to the report (for example total weight).
The weight of each line in the packing list is calculated by Quantity*(Weight of 1 item). I cannot manage to calculate the total weight, since the weight of each line is not stored anywhere (so something as easy as SUM(weight) does not work).
Is there maybe some way to keep track of a running total with a few lines of code, which I print at the bottom of the report in the end?

Thanks in advance!

LCosta · 2017-01-23

On the "OnAfterGetRecord" of the DataItem that is processing the lines, you can add
TotalWeight += Weight;

Being TotalWeight a decimal field that u declare on the global variables and Weight the field that is returned from your table (or the equation you just described).
Then just send him to the report.

Kishorm · 2017-01-23

That is possible but a simpler option is to calculate a "Line Weight" value for each line in C/AL and then include this in the dataset - then you can use SUM in RDLC. As it's for a Packing List report it won't add much to the size of the dataset so you won't have problems about it getting too big or slow.

@LCosta you beat my post by 1 min

@wml both my solution and LCosta's solution amount to the same thing really - go with either option

LCosta · 2017-01-23

On the "OnAfterGetRecord" of the DataItem that is processing the lines, you can add
TotalWeight += Weight;

Being TotalWeight a decimal field that u declare on the global variables and Weight the field that is returned from your table (or the equation you just described).
Then just send him to the report.

Kishorm · 2017-01-23

That is possible but a simpler option is to calculate a "Line Weight" value for each line in C/AL and then include this in the dataset - then you can use SUM in RDLC. As it's for a Packing List report it won't add much to the size of the dataset so you won't have problems about it getting too big or slow.

@LCosta you beat my post by 1 min

@wml both my solution and LCosta's solution amount to the same thing really - go with either option

saravanans87 · 2017-01-24

I hope the above suggestion might resolve your issue but in case If it didn't then try using VB code in RDLC by creating some custom functions and do the calculation inside the functions. keep in mind to clear the variables whenever the group changes.

wml · 2017-01-24

Thanks for the input everyone! I went with the solution proposed by Kishorm and it seems to work fine. Since I'm still new to C/AL coding, it was very useful to know where to add my code, so thanks for that as well LCosta

Adding a total to a NAV report

Best Answers

Answers

Categories