most recent activity with condition
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!
Re: most recent activity with condition
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.
