How can I display the report information across and then down instead of just down multiple pages?

Question

Using Microsoft SQL Server Reporting Services (SSRS), I'm trying to display a report that has hundreds of results. These results are 3 digits numbers and I don't want to have a 10 pages report. I want the display of the information to go Across, and the down after it reached the end of the row (let's just say I want to have 6 results per row.

How can it be achieved?

Answer 1

Use a matrix/tablix where x is the number of columns you want.

For the row grouping use:

=ceiling(rownumber("Dataset")/x)

For the column grouping use:

=((rownumber("Dataset")-1) mod x)

Answer 2

I'm trying to display the report in SSRS