Hello, I am working on a report where the report shows a list of clients and their details who match a certain criteria. Also i need to show in this report all the client names who are not in the specified criteria. So if i have to display all the excluded clients it is a single column and it is running into a lot of pages which is not looking good as it is a single column. So i was thinking of using multi column sub report for the excluded clients but it seems ssrs does not support multi column sub reports. Is there any other alternative to achieve this. Please let me know. Thanks, Ajay

Hi Ajay Raavi, You could try a matrix subreport. A matrix control expands to multi column table.Sergei

Hi, SSRS supports multi column reports. You need to develop your sub report with multi columns. To enable multi columns report 1. open the report in designer and click outside the report layout area. 2. in the properties window, locate columns property and click the + sign to drill down 3. Set the number of columns in the columns property (2,3 or 4) as required/possible by the report layout. 4. While previewing, right click on the report output area and select print layout to see the multi column output. Note : in normal preview mode, multi column does not get output as desired. please d select print layout. hope this helps. Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH

Hi, SSRS supports multi column reports. You need to develop your sub report with multi columns. To enable multi columns report 1. open the report in designer and click outside the report layout area. 2. in the properties window, locate columns property and click the + sign to drill down 3. Set the number of columns in the columns property (2,3 or 4) as required/possible by the report layout. 4. While previewing, right click on the report output area and select print layout to see the multi column output. Note : in normal preview mode, multi column does not get output as desired. please d select print layout. hope this helps. Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful. BH

Hi Ajay, As Sergei posted, we can use a matrix to display one field in multi-column but without using subreport. For example, if we need to display client names in 5 columns, please refer to the steps below: 1. Add a matrix to the report. 2. Edit the default RowGroup to group on the expression like =Ceiling(RowNumber(nothing)/5) 3. Edit the default ColumnGroup to group on the expression like =RowNumber(nothing) mod 5 4. Drag the client field from the dataset and drop to the data cell in the matrix. After that, the client will be displayed in the matrix in 5 columns. You can also remove the row header and column header of the matrix. Thanks, Tony ChainPlease remember to mark the replies as answers if they help and unmark them if they provide no help