Generate one string from several records in Crystal 9.2 1

[lana123]

Hi, people.
I work with Crystal 9.2 and Oracle.
I have two tables: first has records with all the information which I need, second has the id_fk, date and field"Notes" which I have to attach to the records in the first table.
Here the problem: there are several rows of notes for one id in the second table (different date of the notes) and in report I get several duplicate records (they only differ by note contents) instead of one.
I want to get one long string, which would be created from several rows of notes with one id_fk in the second table and connected with the record in the first table.
I'll be really appreciated for any ideas.
Thanks in advance.

Lana

 

[rhinok]

Instead of concatenating all notes into one long string, you could simply group by ID, move all other fields into the group header then place only your notes in the detail section. After doing this, you could check the underlay section in the Group Header field so that the header fields appear on the same line as the beginning of the notes.