How do I add the most current note to a listing report

We send out a daily report in excel format to our customers with statuses of their requests.  The users would also like to get the notes entered from the day before displayed in the report.  Has anyone solved this issue in SBM and can provide steps for what to do?