Please help me to make report like that !

haihth
haihth Member Posts: 32
edited 2011-04-08 in NAV/Navision Classic Client
Hi all mem !

I have to make a report like that: ( from Sales Lines table)

Product Group Code 1
---Item no 11
Quantity
Amount
---Item no 12
Quantity
Amount
Product Group Code 2
---Item no 21
Quantity
Amount
---Item no 22
Quantity
Amount

Problem is:
If i want to group by Product Group Code, I can't group by quantity of same item no.

Please help me !
Thanks you.

Comments

  • abhinav0408
    abhinav0408 Member Posts: 35
    Just check your GroupTotalFeilds...and corresponding to this check DataItemTableView property and define proper keys,which u want to group
  • deepaknav
    deepaknav Member Posts: 18
    create the composite key : Product Group Code, Item No. (i.e. No. field in the Sales Line table).

    then you group by product group code and within each product group code items can grouped and also quantity can summed.
  • haihth
    haihth Member Posts: 32
    deepaknav wrote:
    create the composite key : Product Group Code, Item No. (i.e. No. field in the Sales Line table).

    then you group by product group code and within each product group code items can grouped and also quantity can summed.

    Thanks your reply.

    But problem is:

    I don't want to group by Product Group Code, I just only want group by same No. Item and use Product Group Code to seperate all item in same Product Group.

    if i do that:
    DataItemTableView:SORTING(Product Group Code,No.) ORDER(Ascending)
    GroupTotalFields:Product Group Code, No.

    Program will group by ProductGroupCode and Item No.

    It's not what i want. I wanna group by Item No. , and seperate all item in same group into a one Product Group.

    Can anybody help me?

Categories