most recent activity with condition

[meuyfsae]

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!

[jade1977]

Group the report Client.
Create a running total.
Field to summarize: the date field
Type of Summary: Maximum
Evaluate: Use a formula {type.field}="Transfer"
On change of group.

I believe that will give you the results you want.