SSRS Repeating header rows on each page- export to PDF problem

Every tablix in SSRS has a property that decides if header rows should be repeated on each page of report.  You can chagne this property in Tablix properties:

devenv_2016-01-19_13-51-36

However, that property is not displayed correctly when exporting to external format, eg. PDF.

If you want to repeat rows heading in tablix in exported file, you have to do as follows:

1. Select tablix

2. In tablix pane, click od down-arrow and check Advanced mode:

devenv_2016-01-19_13-46-25

3. In Advanced mode, choose every (Static) element in Row Groups pane, that you want to repeat on new page. While you selected this element, you have to change “Static row” properties KeepWithGroup = After and RepeatOnNewPage =True:

devenv_2016-01-19_13-50-17

Every (Static) is a single header row displayed in tablix, eg. simple table with one header row have one (Static).

That solution works when you export SSRS reports to PDF and DOCX using SSRS native export feature.

Hope this helps 😉

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s