How would I combine the detail rows of a table to display in one cell?

I have a table with a bunch of detail rows. Instead of having the data being displayed in individual rows, I would like it to be displayed in one cell. How would I do this? I would like to go from this: <img src='http://i.imgur.com/znub3ae.png' alt='Posted Image' class='bbc_img' /> to this: <img src='http://i.imgur.com/iva7Gej.png' alt='Posted Image' class='bbc_img' /> I would assume I would have to do a grouping. But after I do the grouping, then what? Thanks!

Find more posts tagged with

Comments

BRM

Define an aggregation element and select CONCATENATE (or Concatenate Unique if that is what you want) from the list of aggregations available.

mkdz

That worked! Thanks! However, it creates a string that's really long and it doesn't wrap. I tried setting the Whitespace property to Normal, but BIRT doesn't let me do it. It just changes it back to Auto. How do I get the text to wrap to the size of the cell?

micajblock

I just tested it and it wraps for me.

BRM

I tried in in a test report and it wrapped for me too.

mkdz

I changed my separator from "," to ", " and the wrapping worked. I guess BIRT thought that it was one long word since there were no spaces.

mkdz

With "," as the separator: <img src='http://i.imgur.com/Cfeq8xg.png' alt='Posted Image' class='bbc_img' /> With ", " as the separator: 
<img src='http://i.imgur.com/geVB2tA.png' alt='Posted Image' class='bbc_img' />