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?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

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

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
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
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
SSRS

From novice to tech pro — start learning today.