Thanks for reply, My report output is correct, but i want insert these data into table.
item No Location Quantity
10 Pune 10
10 Pune 5
30 Pune 20
This are report body lines
Then Total is group on Item No & Location.
Then Report Footer is
10 Pune 15
Then this report footer data want to insert on temporary table.
I Think you are very New to NAV 2016/RDLC
1.In the Body Add Table
2.Add Respective fields in Table
3.add grouping Like Below With Footer
4.Select Location Code Example i have Selected No.
In Footer Add fields Which you want the totals As
above gives the Total Qty in particular Location..
6.Done Your report.(I assume you know How to add fields in report and how to Use Sum Function)
If you Find Any Issues please Let Me Know .
Before that read some Blogs on how to group in Rdlc reports
Hii First think when we upgrade the Nav 2009 report in to Nav 2016 report, In Nav 2009 we have work in Section and in Nav 2016 we have work in RDLC Layout , both have many differences.
Then You Have to make a group or Using Code
1. take a Code variable name it "LocationG"
2.in Onaftergetrecord Write Like
IF Location ='' Then Begin
Location := yourfirstLocationwillbeCopied;
If Location = YourLoaction Then Begin
Add Whatever Total Fieldsyou want to do
total += qty;
If Location <> yourLocation Then Begin //Next Location
1.Insert the Totals
2.Clear the totals Globals
3.And Again allocate Location
4.Initiate Next totals Again for New Location