Solved

SSRS Report Formatting  - Multiple Columns on a page

Posted on 2013-11-26
1
2,031 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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

Complete VMware vSphere® ESX(i) & Hyper-V Backup

Capture your entire system, including the host, with patented disk imaging integrated with VMware VADP / Microsoft VSS and RCT. RTOs is as low as 15 seconds with Acronis Active Restore™. You can enjoy unlimited P2V/V2V migrations from any source (even from a different hypervisor)

Question has a verified solution.

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

I am showing a way to read/import the excel data in table using SQL server 2005... Suppose there is an Excel file "Book1" at location "C:\temp" with column "First Name" and "Last Name". Now to import this Excel data into the table, we will use…
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.
NetCrunch network monitor is a highly extensive platform for network monitoring and alert generation. In this video you'll see a live demo of NetCrunch with most notable features explained in a walk-through manner. You'll also get to know the philos…
Michael from AdRem Software explains how to view the most utilized and worst performing nodes in your network, by accessing the Top Charts view in NetCrunch network monitor (https://www.adremsoft.com/). Top Charts is a view in which you can set seve…

688 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