How do I get a related field to display when taking a maximum of a group? 1

[AcctSolver]

I am trying to figure out how to get the appropriate data to appear on a report and need help. I have data that looks like this.
TransNo ActedOn Date
123221 Mary 9/1/2012 8:15
123221 John 9/1/2012 22:15
123221 Fred 9/1/2012 18:15
123222 Mary 9/1/2012 9:15
123222 Fred 9/1/2012 21:13

I need one line per TransNo, it needs to display TransNo, ActedOn and Date, for the maximum of each date per TransNo.
I tried grouping on TransNo then Date, and taking the maximum. That did give me the correct TransNo and Date, but of course when I got the maximum of the ActedOn, it was not related to the date next to it.

I need to obtain the correct ActedOn when I have located the maximum of the Date for each TransNo.

 

[CoSpringsGuy]

Group on transaction number
sort records by date ascending( I assume that is a datetime field)
place TransNo ActedOn Date fields in group footer
suppress details
suppress group header

_____________________________________
Crystal Reports 2008 and XI
Intersystems Cache 2012 ODBC connection

 

[AcctSolver]

Thanks, that is working great.