Can't group by and seperate item !

haihth
haihth Member Posts: 32
edited 2011-04-14 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
---Item no 22
Quantity
Amount
---Item no 23
Quantity
Amount

Problem is:

I wanna group by same No. Item (to have a total quantity ) and use Product Group Code to seperate all item in same Product Group.

If i define TotalGroupBy, program is not seperate item in same product group.

Who can help me, please, thanks!

Comments

  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
    I hope you have done grouping by Product Group Code and Item no.

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • haihth
    haihth Member Posts: 32
    mohana_cse06 wrote:
    I hope you have done grouping by Product Group Code and Item no.

    I did what you say. But it is not what i want.

    I just only want to group by Item No and use Product Group Code to seperate all item in a same product group.

    Can you help me?
  • mohana_cse06
    mohana_cse06 Member Posts: 5,506
    haihth wrote:
    I just only want to group by Item No and use Product Group Code to seperate all item in a same product group.
    this is what grouping will do..

    -Mohana
    http://mohana-dynamicsnav.blogspot.in/
    https://www.facebook.com/MohanaDynamicsNav
  • haihth
    haihth Member Posts: 32
    mohana_cse06 wrote:
    haihth wrote:
    I just only want to group by Item No and use Product Group Code to seperate all item in a same product group.
    this is what grouping will do..

    insert into itemmenu(itemmenuid,parentid,name,site)
    values(40,1,'View Analysis','~/admin_analysis.aspx')

    insert into group_itemmenu(groupid,itemmenuid)
    values(1,40)
    mohana_cse06 wrote:
    haihth wrote:
    I just only want to group by Item No and use Product Group Code to seperate all item in a same product group.
    this is what grouping will do..

    I did that:

    -DataItemTableView:Sorting(Product Group Code,No.)
    -GroupTotalFields:Product Group Code, No.
    -TotalFields:Quantity

    And result is not exactly with expected report.

    If I did that:

    -DataItemTableView:Sorting(Product Group Code,No.)
    -GroupTotalFields:No.
    -TotalFields:Quantity

    Result is: All same item no will group by, but can't seperate all item into same product group.
    (is Product group code in header group section? )

    Anybody can help me?
  • thmartin
    thmartin Member Posts: 90
    GroupTotalFields should be "Product Group Code".

    I guess there is something wrong with your section design.

    I suggest you create the report from scratch again by using the report wizzard.
    This thing is doing almost everything for you that is needed for this report.

    For Sorting select: Product Group Code,No.

    For Grouping select: Product Group Code

    Have a look at the result.
    Thomas Martin
    NAV Developer
  • haihth
    haihth Member Posts: 32
    thmartin wrote:
    GroupTotalFields should be "Product Group Code".

    I guess there is something wrong with your section design.

    I suggest you create the report from scratch again by using the report wizzard.
    This thing is doing almost everything for you that is needed for this report.

    For Sorting select: Product Group Code,No.

    For Grouping select: Product Group Code

    Have a look at the result.

    I did what you say and this is result:
    Group Name
    Item No.
    Quantity
    Amount
    Book
    Book 1 ---1
    5
    Book 1 ---1
    5
    Book 1 ---1
    5
    Book 2 ---7
    12
    CD
    CD 1 ---8
    11
    CD 2 ---1
    4
    CD 2 ---1
    4

    You notice the line Book1, and CD2, it is not group by Item No.
    Can you have any idea?

Categories