SSRS Split Table on Word Export

Question

I'm trying to figure out if it is possible to split a large table onto multiple pages when exporting the report to Microsoft Word.

Let's say I have a large table of data for a report where the columns would spread over 2 pages with multiple pages worth of rows. When I export it to Word, I would like X number of columns to be on the odd page and the remaining number of columns on the even page and the rows of data to match each odd and even page paring (Pages 1,2 | 3,4 | 5,6 | etc.). For example, say I have 100 rows of data and 12 columns, and a page can fit 6 columns and 25 rows. On export, page 1 would have the first 25 row of data and the first 6 columns and on page 2 it would also have the first 25 rows of data and the remaining 6 columns of data. This would repeat on the following pages until the data is all exported. What I'm hoping to create is a booklet of sorts.

Right now, when I export to Word the whole table gets resized to fit the width of the page. Is what I'm trying to do even possible?

Answer 1

Hi @HybridAK
I haven't found an efficient way to achieve your needs. In SSRS, row paging works well, but odd and even page paging by column is difficult.
According to my search, when exporting SSRS report to Word, Word table supports up to 63 columns, when the report has more than 63 columns, Word will split the table. For more details, you can refer to this link: exporting-to-microsoft-word-report-builder-and-ssrs
Best regards,
Aniya