Collapsing Mutilple Fields

[gatorfe]

I have a report that list shop order detail information.  In the erp system there is a section to add up to 5 line items of notes for each shop order.  In the cognos report individual columns for each note have been added.  If there is a shop order that has 3 notes attached, it shows me 3 lines of the detail on the cognos report with one note field filled in on each line.  See attachment.  I want to just have one line show up with the details and the three columns filled in on the same line.  Any suggestions?  Thanks in advance. 

[DanSev]

Group the report at the key level, with subgroups and set the group span to the proper level. The group span (in the properties of a list column) will eliminate duplicate display.

A better way is to concatinate the notes together in a single data item (using a null catch on each one), and only display 'Note'

The data item would look something like this: {Note_All)

if([Note 1] is not null) then ([Note 1]) else ( ' ' ) +
if([Note 2] is not null) then ([Note 2]) else (' ' ) + .....

So if there is no note, you'd end up with 5 spaces. You can reference this data item with another data item calling it like this:
(Note)
trim([Note_All])

that would remove the whitespace. Use this main note in the report as a note column, without pulling in the other note columns.