I'm new to crystal reports and I was trying to create a unique count. For example the records pull look like this:

Date                           ID            Result
12/16/2010 11:15:48   123456     X
12/16/2010 13:24:32   123456     X
12/16/2010 15:17:18   354886     X
12/16/2010 18:48:55   123456     X

And I want to count the result when it equals X, but only the most recent result. So ideally I want the count for this data set to display "2" 1 for each ID. Is there a way to do this?

Thanks in advance

Edited by npatel - 16 Dec 2010 at 7:49am

Actually the the distinct count of ID when the result value = "X" if it's the most recent instance. So if the result is "Y" for a later Date, then "X" is not counted and "Y" is used instead.

Yes the most recent instance defined by the maximum datetime per ID. X and Y are statuses that could vary from 12 different static entries or preset list of possibilities.

Thank You, I'll give that a try and let you know how it worked out.