I have items grouped into categories. Each item has a Comment field. Is it possible to get all the comments of the items in a group and concatenate them into a merged field to the right of the items. This is what my report looks like: Group A Store Walgreens (item1)--Walgreens is a small store (item 1 comment)Store Walmart (item 2)--Walmart is a big store (item 2 comment) I would like to omit the detail comment rows from under the items and concatenate them into a merged cell to the right of the item rows that would read "Walgreens is a small store. Walmart is a big store." This merged cell should span the length of Group A. Any help would be appreciated, thanks.

Hi, I had written a blog post on something similar. Please check if it helps - http://nauzadk.wordpress.com/2012/06/08/ssrs-transposing-a-rowset-into-a-cell/ Regards, Nauzad Kapadia. Please "Mark as Answer" if a post has answered your question or "Vote as Helpful" if it was helpful in some way. Here's why