Would like access to newest Note on a Request, for views and reports

Would like access to newest Note on a Request, for views and reports

Is there a way to show the most current Note for a request on views and reports?   We like to see a detailed description of current status when viewing a list of Requests or when sharing status of a list of requests via a report.  I have created a custom field for us to enter current status into, but since it doesn't keep history, we are losing that trail of information.    It would be nice to either be able to pull the most current Note for display in views and reports.   Or an alternative option would be to capture the contents of the Note when it is added or updated and copy it to a custom field, which could then be displayed on views or reports.  See attachment for a sample of what we would like to see.

                  New to ADSelfService Plus?