I have a report that takes in a bunch of tables and i need to only show the latest comment entered for each loan.

The comments are stored in the table comments along with the date of the comment. In the report just want to show that one comment that was last entered. How do i do this.

{Comments.DateandTime}//date comment was entered

{Comments.RecordType}//type of comment

{Comments.Comment} //comment

Those are the three fields in the table i need. Im using crystal reports 8.5