Repeat table headers in MS Word
Question
Answers
-
Hi TJ,
Word does not repeat header rows on page two and greater, although you set the RepeatOnNewPage property of the static header row in a tablix (table, matrix, or list) to True. You can define explicit page breaks in your 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. However, there is a workaround for this issue, for details please refer to the link below to see Jerry’s reply.
http://social.msdn.microsoft.com/Forums/is/sqlreportingservices/thread/fd58a159-7462-46d8-af44-2d6eb33066feIf you have any questions, please feel free to ask.
Regards,
Charlie LiaoIf you have any feedback on our support, please click here.
Charlie Liao
TechNet Community Support
- Proposed as answer by Avanish Tomar Tuesday, January 15, 2013 3:47 PM
- Marked as answer by Charlie Liao Wednesday, January 23, 2013 6:56 AM
All replies
-
Hi TJ,
Word does not repeat header rows on page two and greater, although you set the RepeatOnNewPage property of the static header row in a tablix (table, matrix, or list) to True. You can define explicit page breaks in your 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. However, there is a workaround for this issue, for details please refer to the link below to see Jerry’s reply.
http://social.msdn.microsoft.com/Forums/is/sqlreportingservices/thread/fd58a159-7462-46d8-af44-2d6eb33066feIf you have any questions, please feel free to ask.
Regards,
Charlie LiaoIf you have any feedback on our support, please click here.
Charlie Liao
TechNet Community Support- Proposed as answer by Avanish Tomar Tuesday, January 15, 2013 3:47 PM
- Marked as answer by Charlie Liao Wednesday, January 23, 2013 6:56 AM
-
Hi TJ,
Word does not repeat header rows on page two and greater, although you set the RepeatOnNewPage property of the static header row in a tablix (table, matrix, or list) to True. You can define explicit page breaks in your 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. However, there is a workaround for this issue, for details please refer to the link below to see Jerry’s reply.
http://social.msdn.microsoft.com/Forums/is/sqlreportingservices/thread/fd58a159-7462-46d8-af44-2d6eb33066feIf you have any questions, please feel free to ask.
Regards,
Charlie LiaoIf you have any feedback on our support, please click here.
Charlie Liao
TechNet Community Support
Thank you Charlie.Is this also the case for MS Excel? When I export the report to MS Excel and then print preview the report I have the same issue (the table header only prints on the first page).
-
Hi TJ,
I have tested it on my environment, if we don’t add page breaks to rectangle, data regions, or groups within data regions for a report, then if we export this report to Microsoft EXCEL, all the report contents will be exported into one worksheet, in this case, there has no page break in excel. If we add page break for the report manually, then the report will be exported into multiple worksheets, if we set the tablix header repeat on each, then the tablix header will repeat in each worksheet. For more information about exporting to EXCEL, please see:
http://msdn.microsoft.com/en-us/library/dd255234.aspx
If you have any questions, please feel free to ask.
Regards,
Charlie LiaoCharlie Liao
TechNet Community Support
