display a comment field (filtering on the date field)

[jewelsan]

Note Table
__________
NoteID int 4
NoteDate datetime 8
CreatorContactID int 4
IsWorkOrderNote tinyint 1
NoteText varchar 1000
CurrentStatus varchar 20

I am creating a report that lists workorders based on buildings. The report is looking great. However all the notes for each workorder dispay. One workorder can have multiple notes (NoteText). I would like the report to list the last note only (the most recent note). The Note table is shown above. Is there a way to have Crystal reports sort the notes by date and list the recent note on the report (not the date)?

Thanks for the help.