Solved

SSRS Report Formatting  - Multiple Columns on a page

Posted on 2013-11-26
1
1,791 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

Zoho SalesIQ

Hassle-free live chat software re-imagined for business growth. 2 users, always free.

Question has a verified solution.

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

Suggested Solutions

This article will describe one method to parse a delimited string into a table of data.   Why would I do that you ask?  Let's say that you need to pass multiple parameters into a stored procedure to search for.  For our sake, we'll say that we wa…
When writing XML code a very difficult part is when we like to remove all the elements or attributes from the XML that have no data. I would like to share a set of recursive MSSQL stored procedures that I have made to remove those elements from …
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This is a video that shows how the OnPage alerts system integrates into ConnectWise, how a trigger is set, how a page is sent via the trigger, and how the SENT, DELIVERED, READ & REPLIED receipts get entered into the internal tab of the ConnectWise …

914 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now