I am designing a report in SRS but need help with the following issue:
In my list of values I have 2004 records but only have 931 distinct names. My table looks like this:
name, place day
smith bathroom 12/04/2007
smith bedroom 12/05/2007
What I need is to have only one smith come up with the most recent day to come up. Distinct wont work because i would get both entries. So I need one entry per name. I was thinking of using a self join but I could not figure out how to implement it.