Nav 2016 report

I have an problem about Nav migration report,
In my previously system Nav 2009  report footer data insert into temporary table , that time code written on Group footer section , but in nav 2016 its not possible, In Nav 2016 data inserts only body wise(not group footerwise) , so i want to insert group wise footer data into tamporary table in nav 2016, so please give me solution for this.
  • Hi,
    You can always group the tables in Nav 2016 i.e in RDLC Moreover you can also define group Headers And Group sub totals and Totals .
    1. Please Be Specific on what you needed .
    2.can You provide any Screenshots Or code Or field By Which you gonna group.
  • In reply to Raja Venkat:

    In my existing nav 2009 system i inserted only group footer data into table through report. that system i write code on group footer section. But in NAV 2016 where i write that code???
    eg": We have Mumbai location wise 3 lines in item ledger entry, then i want their total in single line . and also insert this single line into temporary table.
  • In reply to kalyantupe45:

    Hii
    i Think you want location wise total in nav 2016 report, you need grouping of the table row regarding location wise.
  • In reply to Akkrahul:

    Thanks for reply, My report output is correct, but i want insert these data into table.

    ex:

    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

    item No    Location   Quantity

    10                Pune             15

    30                Pune             20

     

    Then this report footer data want to insert on temporary table.

  • In reply to kalyantupe45:

    Hi,

    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

    Example :Sum(Fields!Qty.Value)

    above gives the Total Qty in particular Location..

    5.

     

    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 

  • In reply to Raja Venkat:

    My issue about insert data into table not report layout.
    RecLocwiseqty - is my temporary table.

    RecLocwiseqty.INIT;
    recLocwiseqty.ItemNo:= Item Ledger Entry.Item No;
    recLocwiseqty.Location:= Item Ledger Entry.Location;
    recLocwiseqty.Quantity:=Item Ledger Entry.Quantity;
    recLocwiseqty.insert;

    I want to insert report footer data into table(LocwiseQty )
  • In reply to kalyantupe45:

    insert data Item No & Location Groupwise
  • In reply to kalyantupe45:

    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.

  • In reply to kalyantupe45:

    Ok,

    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;
    End;
    
    If Location = YourLoaction Then Begin
    Add Whatever Total Fieldsyou want to do
    Ex:-
    total += qty;
    End;
    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
    End;
    

  • In reply to Raja Venkat:

    Thanx for reply, it's really help me...
Related