I have a GridView, which displays a result set, but many of the field values are duplciates (ie. it is selecting a list of all relationships for person "X", so person "X"'s name, city, address, etc. shows up in every single result). Is there a way that I can tell the GridView to "hide duplicates" in much the same way you can do this for reports in SS Reporting Services?
All help is greatly appreicated!