<div>
<div class="content wysiwyg-content">
I'm trying to keep tablix column headers repeating on each new page of an SSRS 2008 report. If I click on Print View in BIDS for a report, having set what I believe are the right options in the static advanced mode properties, they appear as expected in preview mode. If I then export to excel, for sheets that go over one page, the column headers do not repeat. How do I fix this please or is it a bug with the Excel exportation?
</div>
</div>


I'm trying to keep tablix column headers repeating on each new page of an SSRS 2008 report. If I click on Print View in BIDS for a report, having set what I believe are the right options in the static advanced mode properties, they appear as expected in preview mode. If I then export to excel, for sheets that go over one page, the column headers do not repeat. How do I fix this please or is it a bug with the Excel exportation?

Column Headers repeated on each page in design and run mode but not when exported to excel in SSRS 2008

SQL Server Reporting Services (SSRS) is a server-based report generation software system from Microsoft. It can prepare and deliver a variety of interactive and printed reports and is administered via a web interface or its web service. Its web services interface also supports the development of custom reporting applications. Finally, SSRS can also be integrated with SharePoint. SSRS competes with other business intelligence tools, most prominently Crystal Reports.

SSRS

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.