Cumulative variables on Nav 2013 RDLC

Navca

Hi everyone, could anyone please tell me how to create a cumulative variable on Nav 2013 RDLC reports that gathers the value of a field of the dataset? In addition, I need that variable to be reset (value = 0) every time there is a group change. On the previous Nav reports tool it was very easy to do this, as you could modify CAL variables from the layout, but with this new version you cannot do it that way…

Thank you

lakshanvindana

2 options for this according to your grouping.

1. if the group is in data item wise (report has more than 1 data item)

---

you can calculate it in the data item coding

2. if the group is in the data item (ex:report has 1 data item)

---

you can calculate it in the RDLC layout report coding

clausl

Check out my Video and Report here, it has all you need:

http://mibuso.com/blogs/clausl/2014/03/30/how-do-i-create-transfooter-and-transheader-in-microsoft-dynamics-nav-2013-r2/

/Claus Lundstrøm