SRSS Report mailing list

I need to create name badges for an upcoming event.  My badges are 3 x 4 and the report should have 6 individual badges on it.  How do I create a report with 2 columns and 3 'rows'?  How do I create my report so that each of the six 'parts' gets a different record?
Who is Participating?
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.

Feridun KadirPrincipal ConsultantCommented:
If this is for Dynamics CRM, I think you will find it quicker and easier to do a mail merge with Word (select labels in Word).
You may have to use a matrix table, which will expand to the right and downward.
ACUIWebDeveloperAuthor Commented:
feredun - yes, this is for Dynamics CRM.  If the event just needed a badge, a mail merge would suffice (though my supervisor still wants a report so the registration desk person at the event can just run the report for any last minute arrivals.  That, and we have a couple of larger events that will have tickets to other events included.

planocz - how do I make the matrix repeat by row and by column?
Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

ACUIWebDeveloperAuthor Commented:
When I try to use a matrix, here is my result...

Is there a way to a) line all the names up in one column? and b) hide the first column (the visibility option is grayed out)?
ACUIWebDeveloperAuthor Commented:
I need to make something like this:

Where each cell contains a collection of fields from a record.  I can make this happen with one column, but I need to make it happen with 2.  What happens now is that the first column is simply duplicated in the second.
ACUIWebDeveloperAuthor Commented:
Ok, I found 'a' solution.  I created two tables that pulled from the same dataset and set the visibility on the first to hide the even rows and the other, the odd.  I imagine it isn't the cleanest method but it works.

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
ACUIWebDeveloperAuthor Commented:
This is not a great way to solve this problem.  In essence I am querying twice and filtering the results based on row number.  I was unable to figure out how to make 2 columns and have each column continue into the next.
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
Microsoft Dynamics

From novice to tech pro — start learning today.

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.