Combine Rows

building reports webintelligence
1

Please see attachment.

My current report shows 3 rows all with the same [ID NUM] and data except each row has a different work note [NOTE]. What I am trying to do is combine all the work notes into 1 field so I only have 1 row for each [ID NUM].
Is this doable?
I am running BOXIR3 SP4.
Book1.xls (26.0 KB)

ribcage :us: (BOB member since 2006-09-01)

2

Check this out:
https://bobj-board.org/t/213879
http://irfansworld.wordpress.com/tag/business-objects/

Thanks,
Raghvendra Deshpande

Raghvendra Deshpande :india: (BOB member since 2008-05-26)

3

I think this works but it looks like it is removing records where I have no notes. I still want to see those as well. I think it is the last variable with the if is null that is causing that problem.

ribcage :us: (BOB member since 2006-09-01)