Forum Discussion
Advocate IRepeat Column headers on paginated reports (Excel, Docs export)
Hi DatamirHub
Unlike PDF exports, Excel does not have defined "pages", so the settings to repeat row headers on each page (like
RepeatOnNewPageor "Repeat header rows on each page") do not apply when exporting to Excel or Word.This is why the headers repeat correctly in paginated reports and PDF exports, but not in Excel or Docs.
Workarounds:
-
In Excel, row headers can be set to repeat manually after export by using Page Layout → Print Titles. This is not controlled from SSRS.
-
A possible but impractical workaround is to insert the header rows manually every N rows.
-
In Word exports, behavior is inconsistent and depends on how the table structure is rendered.
This is a known limitation of paginated reports when exporting to non-paginated formats like Excel or Word.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
-
Super UserHi DatamirHub
Unlike PDF exports, Excel does not have defined "pages", so the settings to repeat row headers on each page (like RepeatOnNewPage or "Repeat header rows on each page") do not apply when exporting to Excel or Word.
This is why the headers repeat correctly in paginated reports and PDF exports, but not in Excel or Docs.
Workarounds:
-
In Excel, row headers can be set to repeat manually after export by using Page Layout → Print Titles. This is not controlled from SSRS.
-
A possible but impractical workaround is to insert the header rows manually every N rows.
-
In Word exports, behavior is inconsistent and depends on how the table structure is rendered.
This is a known limitation of paginated reports when exporting to non-paginated formats like Excel or Word.
If this post helps, then please consider Accepting it as the solution to help the other members find it more quickly.
This is a pretty standard requirement for a paginated report ... seems like a significant miss to require users to have to manually perform this step everytime they run a report. Is this going to be updated any time soon?
Dashboards are great for many use cases, but for regulated environments, such a pharmaceuticals, that require reports to be filed for points in time, this is a real headache for endusers.
