This is probably really easy but I am quite new to Crystal.

 

I have report that shows reference no, summary and notes (example below). For each reference there can be any number of notes, numbered as they are added - 1,2,3 etc. I can use the select expert to show note 1 or note 2 but what I would actually like the report to do is just to show me the last note for each reference which will obviously be a different note number for each reference depending on how many have been added. How do I do this?

 

Reference     Summary             Note No    Note Detail

12345           Account locked     1              Tried to call customer no reply

                                                 2              Tried again - no reply

 

 

I hope this makes sense this is my first time using a forum.

Thanks

Thanks very much