Creating a grouped report

tompynation

Hi, i've added the following field to the Item table: 'UN code'

When a user enters an item no on the Sales Order, this 'UN code' gets copied into this sales line...

So far so good.

Now i created a report which should print all used UN code's, but this shouldnt show doubles.

So inside the report i have the sales lines. Set the GroupTotalFields to 'UN code'.

Created and set this key on the sales line report item.

ANd then added a groupfooter section to the report in which i print the
UN Code

Problem is now that it prints all used UN code, so doubles as well
And they arent grouped?

How could i just print a list of Unique used UN codes in the sales lines?

tompynation

ok, forget this...

I used the wrong key... It was grouping per item and inside this group per UN Code

But it had just to group on the UN code not on the Item code