SSRS Report Formatting  - Multiple Columns on a page

Posted on 2013-11-26
Medium Priority
Last Modified: 2013-11-26
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?
Question by:Claudia Carlotti
1 Comment

Accepted Solution

Claudia Carlotti earned 0 total points
ID: 39678449
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!


Featured Post

Get expert help—faster!

Need expert help—fast? Use the Help Bell for personalized assistance getting answers to your important questions.

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.

Join & Write a Comment

Recently, when I was asked to create a new SQL 2005 cluster, Microsoft released a new service pack for MS SQL 2005 what is Service Pack 3. When I finished the installation of MS SQL 2005 I found myself troubled why the installation of SP3 failed …
This article explains how to reset the password of the sa account on a Microsoft SQL Server.  The steps in this article work in SQL 2005, 2008, 2008 R2, 2012, 2014 and 2016.
SQL Database Recovery Software repairs the MDF & NDF Files, corrupted due to hardware related issues or software related errors. Provides preview of recovered database objects and allows saving in either MSSQL, CSV, HTML or XLS format. Ensures recov…
Stellar Phoenix SQL Database Repair software easily fixes the suspect mode issue of SQL Server database. It is a simple process to bring the database from suspect mode to normal mode. Check out the video and fix the SQL database suspect mode problem.

621 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question