How to put multiple items into one column in SSRS

I would like to build a report that has 2 or more item values, stacked on top of each other within the same column. I have a sample attached. Specific to my example, I want the first column to display the Const ID & Name the way the second column is displaying Name & Date.

Desired report sample
I am using SSMS 2008 R2 and Visual Studio 2008

Thanks!
rwaterzAsked:
Who is Participating?
 
JestersGrindCommented:
It looks like you're grouping on ConstID/Name.  I think SSRS is pretty strict about having one thing per column.  You might be able to make the name column really small so that they appear to be stacked on top of one another.
0
 
bcnagelCommented:
Couldn't you just use an expression for the field like "=Fields!ConstID.Value & chr(13) & chr(10) & Fields!Name.Value" (without the quotes)? Then it would *look* like the fields were on top of each other, but really there would just be a return and line feed after ConstID. Does that make sense?
0
 
rwaterzAuthor Commented:
I had to play around with the groupings. I needed to use adjacent and child groups. I don't completely understand what I did but after mucking around with the various grouping options, I got it to look the way I wanted.
0
 
rwaterzAuthor Commented:
Here's a screen shot of what the report design looks like:
Report Design
I also realize there is likely a better way to have done this.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.