Items by Product Group

navmannen
navmannen Member Posts: 9
Hi!
I have a report, where I have grouped Items by Product Group like this:

ProductGroup1
Item1
ProductGroup1
Item3
ProductGroup1
Item7
ProductGroup2
Item1
ProductGroup2
Item8
ProductGroup3
Item0
etc.

How can I change this report so, that each Product Group appears only once like this:

ProductGroup1
Item1
Item3
Item7
ProductGroup2
Item1
Item8
ProductGroup3
Item0
etc.

The idea is, that Items are on straight vertical line (somehow I did not succeed to demonstrate this).

Waiting for your help,
navmannen

Comments

  • ara3n
    ara3n Member Posts: 9,258
    You need to add groupheader and move the text controls to the groupheader from the body section.
    Ahmed Rashed Amini
    Independent Consultant/Developer


    blog: https://dynamicsuser.net/nav/b/ara3n
  • Nehaa
    Nehaa Member Posts: 6
    Hi,
    Could you tell me how you were able to assign different product group code to same item? VIZ Prod grp 1- Item1, Prod grp 2- Item 1..