I am able to repeat header columns for a table in each page when viewing a report.
I now need these headers to be shown in each page when printing or saving to word etc
Technology Tips and News
I am able to repeat header columns for a table in each page when viewing a report.
I now need these headers to be shown in each page when printing or saving to word etc
Hi DarrenOD,
According to your description, when you export the report to Word, column headers wont repeat on each page, right?
In Reporting Services, Word does not repeat header rows on page two and greater, although we set the RepeatOnNewPage property of the static header row in a tablix (table, matrix, or list) to True. This is a limitation in Word render. We can define explicit page breaks in the report to force header rows to appear on new pages. However, because Word applies its own pagination to the rendered report exported to Word, results might vary and the header row might not repeat predictably. The static header row is the row that contains the column headings.
So in your scenario, the workaround for this issue is to limit each page displayed rows and add page breaks. You can refer to the workaround from this similar thread: SSRS 2008: When exporting to Word, Repeat header rows on each page functionality does not work.
Reference:
Exporting to Microsoft Word (Report Builder 3.0 and SSRS)
If you have any question, please feel free to ask.
Best regards,
Qiuyun Yu