Groups | Blog | Home
all groups > sql server reporting services > august 2006 >

sql server reporting services : Possible todo some form of DISTINCT filtering?


Tarun Mistry
8/3/2006 5:43:08 PM
Hi guys, I have a dataset that returns rows that look like the following

field | value
-----------
1 | 7
1 | 7
2 | 4
8 | 90

Is it possible to remove the duplicate (1 | 7) row directly within a LIST
control (or similar?)? I cannot use a DISTINCT directly in the SQL as
elsewhere I need to display the duplicate row.

Thanks for any help
Taz

Tarun Mistry
8/3/2006 6:26:02 PM
Silly me, thats what grouping is for lol.

Thanks anyways
Taz

AddThis Social Bookmark Button