SSRS Report Formatting - Multiple Columns on a page

We have some reports that print out simple text responses.  We select these into a dataset and display them in a table.  There may be 8 or 10 pages of these comments, but they are often short.  We would like to print them in landscape, in two or three columns per page.  

For example, in WORD you can format the page so that the text wraps into the specified number of columns.  Is there a way to do this in SSRS 2005 or 2008?
Claudia CarlottiIT DirectorAsked:
Who is Participating?
 
Claudia CarlottiConnect With a Mentor IT DirectorAuthor Commented:
I found the answer in a Wrox article on printing address labels in multi-column format.  

1)  Select the body of the report.  
2)  Set the column property to more than 1.
3) The additional column(s) appears.  They are not editable.
4) Fill the left region with a data container, such as a table.  Ensure that the table fills the region, and that the combination of columns does not exceed the page width in the report properties page.  
5)  In the Preview mode, only a single column will display.  However; if you select Print Preview, you will see multiple columns displayed.  
6)  The report will print or export multiple columns.
7)  Now that you see it works, work with it for desired table headings, groups, etc.  It works!

Thanks.
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.