SSRS: Break Table Data in Vertical Format

SSRS: Break the Table Data in Vertical Format.

We generally get the requirement to break the table records, so that some specific counts of records appear in each page. For ex- if your table has 100 records and you want to break this table in 20 records each page then we use “Ceiling Function” and add page break BUT if I want to break this table Vertically like below:

This is only a single table which is breaking vertically, so below are some steps to achieve this funcanality.

1. Create a ROW Group on Tablix and write expression “Ceiling(ROWNUMBER(NOTHING) / 5)”
2. Create COLUMN Group on Tablix and write expression “(ROWNUMBER(NOTHING)  ) mod 5”
3. Add Fields and Lable as below:

4. You can change Ceiling and MOD value as per choice but if both remain same then it would be good.

Preview the Report and you will get desired output: Thanks.