Hello code gurus,

Does anyone know how to display the most recent visit date with a set condition in Crystal Report XI. Here's a sample table

Client Visit Date Type
A 01/01/10 Transfer
A 01/30/10 Yes (most recent date for this client)
B 02/02/10 Yes
B 02/05/10 No
B 02/20/10 Transfer (most recent date for this client)
C 02/20/10 Transfer (most recent date for this client)

I want to only display clients who has the type "Transfer" on the most recent visit date. The results should only include client B and C.

I have tried Groups and sorting, but it I am not finding what I need.
Please help. Thanks!