Is there a way to format a report so that there are three columns on a page, instead of one long column? I have a list that has just 3 elements and it only takes 1/4 of the page, width-wise, but takes 3 pages to print. I would like to fit it on on page in a format that is easier to read than one long list.

Try creating 3 rectangles to accomplish this. Make sure that each rectangle is exactly the same length and the top of each is exactly at the same level. Hope this helps, --JoshJosh George LiveLogic, LLC

if you have choice export the report to word and try Renderformat options to divide it three columns if you have not you have much work to do with lines and rectangles create three rectangle manually distubute data over them by using necessrary queries of expressionshttp://www.sdtslmn.com

Hi Chris, To your first question,we have a workaround to format a report to contain three columns on a page instead of one long column.That is adding column break to your report.Below are the detailed steps for your reference: § Step one: copy the following code to the custom code area Dim FlagTable As System.Collections.Hashtable Dim Flag AS Integer Function MyFunc(ByVal NewValue As Object) As Integer If (FlagTable Is Nothing) Then FlagTable = New System.Collections.Hashtable End If If (NewValue Is Nothing) Then NewValue = "-" End If If (Not FlagTable .Contains(NewValue )) Then Flag =Flag + 1 FlagTable.Add(NewValue, nothing) End If MyFunc = Flag End Function § Step two: Add a list to your report 1. Right-click the list ,and then select Properties. 2. Click Edit details group… button 3. Type in the expression =Ceiling(Code.MyFunc(Fields!Month.Value)/6) Note: ü Fields!Month.Value is your column group datafield ü 6 is the number of the columns you want to display in a row § Step three: Sort the dataset by column group field, and then drag the matrix into the list 1. Switch to the data tab. 2. Add ‘order by datafield’ to sort the dataset by the column group datafield here is a example: select * from vProductProfitability where Year=2003 and MonthNumberOfYear in (1,2,3,4,5,6,7,8,9,10,11,12) order by MonthNumberOfYear 3. Drag the matrix into the list and preview the report. Then preview the report ,you will see your tablix with a certain column defined by yourself. To your second question,you would like to fit the list on one page in a format that is easier to read than one long list. Here I want to confirm with you, have you already add a page break to your tablix, if so one list will display in one page.So you can clear the checkbox of page break.Beside this,you can drag the lower edge of list up to place it just below the lower edge of the matrix to shrink the space between the repeating regions. If you have further question,please feel free to ask. Regards, Challen Foo

Hi Chris, Does my reply solve your issue, if so I mark it as answer, if not you can supply the detailed information of your requirement. That will help us understand the issue properly to give the relevant resolutions. Best regards, Challen Fu

Hi Challen, I'm trying to implement your solution however it seems like the list turns into a tablix. What i'm trying to do is a bit different. My data can vary from a single column to about 15 columns, and based on the number of columns I want to utilize my whitespace as effectively as i can. for instance, if my data comprises of 3 columns then I would like it to print newspaper style across 3 segments, if however it is about 5 columns, then display it across 2 newspaper style columns, or if it is 15 then a single page. is this something that can be done dynamically? i know the column property exists but not sure how i can do it dynamically. thank you! ps i'm using ssrs 2008

This thead is a little old could you please create a new one, we will handle it on time.Please remember to mark the replies as answers if they help and unmark them if they provide no help.

i have... http://social.msdn.microsoft.com/Forums/en-US/sqlreportingservices/thread/5c63439c-ecae-4fb7-8074-d872243be814 no responses yet.