I've seen similar questions asked but nothing specific in terms of if it is possible or if there are better ways to do it.

A customer has a request that in a report which runs for single company records only, they would like to get the notes listed. The report shows some fields from the company entity. There is a custom entity called Application. A company can have many applications. Notes are available at the Application level. When they print this report, they have asked if possible to have a section at the end that shows all the notes against the application. I appreciate that there could potentially be a limitless number of notes, but in reality, it'll be no more than 10 to 15 short notes.

I've told them it isn't easily possible to create a view that does that. I know there are ways to do it via stored procedures. I told them I could get them the latest note, but they have specifically asked for all notes. In Crystal this would be relatively easy by having a sub report but CRMs reporting is not as feature filled.

Any suggestions?