SQL Server Report Builder List expanding right and across

Question

How to configure Report Builder List component to expand right and across?

Something like this:

It looks like you want the results to appear in two **columns**. [This question](http://stackoverflow.com/questions/10882784/ssrs-how-to-continue-data-to-next-column) should have what you're looking for, try using the 'fake multi-column' answer from Chris Lätta. — Pete Rennard-Cumming, Mar 30 '16 at 09:15

score 1 · Accepted Answer · answered Sep 24 '17 at 22:26

Solution found here:

On the Detail row of the first table, for the Visibility-Hidden property:

=iif((RowNumber(Nothing) Mod 2) = 1, False, True)

On the Detail row of the second table, for the Visibility-Hidden property:

=iif((RowNumber(Nothing) Mod 2) = 1, True, False)

score 0 · Answer 2 · answered Jul 27 '22 at 07:04

0

Only this worked for me, placing here for future reference. The Report > Columns property and hacks were a no go. Using Power BI Report Builder (not SSRS, not PBI Desktop :) 08-Horizontal Table Report

answered Jul 27 '22 at 07:04

Gary Thomann

576
6
17

SQL Server Report Builder List expanding right and across

2 Answers2