distinct values on a dataset columns selection

SheepK

Hi,


I have a dataset with a lot of columns. Let's say column A to column Z.

This dataset contains client orders.

Example :

[Client 1] [Manager in Charge X] [since 1994] [ORDER 1]
[Client 2] [Manager in Charge Y] [since 2002] [ORDER 2]
[Client 2] [Manager in Charge Y] [since 2002] [ORDER 3]
[Client 1] [Manager in Charge X] [since 1994] [ORDER 4]
[Client 1] [Manager in Charge X] [since 1994] [ORDER 5]
[Client 2] [Manager in Charge Y] [since 2002] [ORDER 6]
[Client 3] [Manager in Charge Z] [since 1998] [ORDER 7]

I would like to display a table with the list of distinct clients.

How can I manage to get distinct clients in a table and display for instance column A to column C (that are identical for a given client)?

Example :

[Client 1] [Manager in Charge X] [since 1994]
[Client 2] [Manager in Charge Y] [since 2002]
[Client 3] [Manager in Charge Z] [since 1998]


Thanks.

bhanley

The easiest solution would be to create a table with a series of groups on it. Each column would in effect be a sub-group on the preceding column's data. The difference in this table would be that you would have no details rows, just the group data itself.