I've put together this question in order to understand if it is possible to arrange data into some kind of flow layout within SQL Reporting Services. I have a query that will return the following DataSet: Title RowRecord1 RowRecord2 DataRecord My Test Some Row1 Test 1 D1 My Test Some Row1 Test 1 D2 My Test Some Row1 Test 1 D3 My Test Some Row1 Test 1 D4 My Test Some Row1 Test 1 D5 My Test Some Row2 Test 222 D1 My Test Some Row2 Test 222 D2 My Test Some Row2 Test 222 D3 I want the report to actually be output as follows: Title: My Test Some Row1 Test 1 D1 D2 D3 D4 D5 Some Row2 Test 222 D1 D2 D3 Basically Title repeats once for the report. Grouping is on RowRecord1 and RowRecord2. However the layout for DataRecord I want to add if possible a TextBox with a border around with the data in that fills from the left to the right - basically sequentially add each DataRecord from left to right until the "line" is filled then start on a new one. I've tried this in Crystal Reports with no luck, so was hoping SQL Server Reporting Services could offer a solution. Thanks Andez Andez (Please mark as answer if it helps)

this can be acheived by using either via matrix report or via using Groups in simple tabulated reports. Just Check it out.Amit Please mark as answer if helpful http://fascinatingsql.wordpress.com/

Thanks for the info Amit, will try it out.Andez (Please mark as answer if it helps)

hi Andez, Please mark my post as answer if found helpfulAmit Please mark as answer if helpful http://fascinatingsql.wordpress.com/

Hi Amit, I've had a play with it. I have managed to get something similar to what I was looking for using the Matrix. From this I have RowRecord1 and RowRecord2 as my Row Groups. DataRecord is my Column Group. However, there can be quite a lot of DataRecords (say up to 40) in some groups, so I would like to restrict the number of columns that get displayed per row - so break onto a new line. I am guessing this won't be achievable? Any thoughts? Thanks AndezAndez (Please mark as answer if it helps)

This is what my report looks like with matrix and table: Andez (Please mark as answer if it helps)

Hi Andez, Delete the details row group in the group pane of the table, you will get the same result as using matrix. When you delete, it will ask to "delete actual rows" vs. "Delete group only". In that box just slect "delete group only". If you have any questions, please feel free to ask. Regards, Charlie Liao

Hi Andez, I dont think it is possible to cut down columns into next row.Amit Please mark as answer if helpful http://fascinatingsql.wordpress.com/