Showing one occurance of the record

[aamkumar]

I am using Crystal XI

If I have a table like

Col1 Col2 Col3
A Fuu Ab
A Faa bc
B Fee ca
C Fun ef
D Free gh
D Fis ij
D Fic kl


I have to display just one occurance of the record that has multiple of the same field in Col1 then what method should I use.

Like out of these two records
A Fuu Ab
A Faa bc I want to display any one of the occurance.


Thanks

 

[Bloke152]

you could group by col2