Solved

SSRS Report Formatting  - Multiple Columns on a page

Posted on 2013-11-26
1
1,957 Views
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?
0
Comment
Question by:Vachik
1 Comment
 

Accepted Solution

by:
Vachik 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!

Thanks.
0

Featured Post

Optimizing Cloud Backup for Low Bandwidth

With cloud storage prices going down a growing number of SMBs start to use it for backup storage. Unfortunately, business data volume rarely fits the average Internet speed. This article provides an overview of main Internet speed challenges and reveals backup best practices.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

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 …
Use this article to create a batch file to backup a Microsoft SQL Server database to a Windows folder.  The folder can be on the local hard drive or on a network share.  This batch file will query the SQL server to get the current date & time and wi…
In a recent question (https://www.experts-exchange.com/questions/29004105/Run-AutoHotkey-script-directly-from-Notepad.html) here at Experts Exchange, a member asked how to run an AutoHotkey script (.AHK) directly from Notepad++ (aka NPP). This video…

733 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