April 4, 2011 at 7:58 am
Hello,
I would like to find a way to change the way results in a table are displayed in my report. The data is grouped by one field and under each group heading there are details displayed in one column (so the table is one column wide.).
There are normally between 10 and 20 results under each heading and they are codes which consist of 3-6 letters (or numbers).
Rather than displaying these all in one column I'd like to display them all on one (or more if there's too many) row separated by commas or maybe just spaces. This would save a lot of space on my report page and make the report look a lot better.
Thanks, hope I've explained this in a way that makes sense, not sure how to describe it!
Stephen
August 22, 2011 at 8:18 am
Look at the following article about using CTEs to concatenate field values, to see if this might resolve your problem:
http://www.codeproject.com/KB/reporting-services/Concatenate_Field_Values.aspx
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply