Report Builder expand table horizontally when get to end of page

[_Random_]

I am running into an issue with getting a table to expand horizontally instead of vertically in Report Builder. I have a 12 tables and they have either 2 or 3 columns each. Currently I have the tables expand vertically when more data is added so they run onto multiple pages. I have just been asked to make the tables be broken down so some tables will have their own page.

The goal is to be able to make those tables expand horizontally across the page once they reach the bottom of the page. 

Currently the table is like this:                                                                      The goal will be like this:

Person 1 | 123                                                                              Person 1 | 123           Person 4 | 456              Person 7 | 789

Person 2 | 234                                                                              Person 2 | 234           Person 5 | 567              Person 8 | 890

Person 3 | 345                                                                              Person 3 | 345           Person 6 | 678

Person 4 | 456                                                                                                        

Person 5 | 567                                                                                                             

Person 6 | 678                                                                                                                                                                              

Person 7 | 789                                                                                                         

Person 8 | 890                                   

Any help is appreciated!

[v-jiewu-msft · Accepted solution]

Hi @_Random_ ,

Based on the description, try to select properties and click on layout tab, set the number of columns.

Viewing the following documents to learn more information.

reporting services - How to expand Parent groups horizontally in ssrs reports instead of breaking th...

Best Regards,

Wisdom Wu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.