SSRS Split Table on Word Export

HybridAK 1 Reputation point
2022-10-31T19:33:09.407+00:00

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?

SQL Server Reporting Services
SQL Server Reporting Services
A SQL Server technology that supports the creation, management, and delivery of both traditional, paper-oriented reports and interactive, web-based reports.
2,849 questions
0 comments No comments
{count} votes

1 answer

Sort by: Most helpful
  1. AniyaTang-MSFT 12,341 Reputation points Microsoft Vendor
    2022-11-01T07:04:50.837+00:00

    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

    0 comments No comments