SSRS - Print tablix row header on each new page

0
votes

I have a tablix which it has assigned a dataset. Tablix iterates over the dataset returned. I have placed a rectangle object with content within tablix row header and check the option to print row headers on each new page in tablix properties. First row of the tablix corresponds to the row header and second row contains is a subreport that contains a chart that is generated based on the data returned by the dataset on each iteration (at each iteration a new chart is created with the appropiate data).

My problem is when a new page starts, the row header is not printed at the beginning of the new page. The first time, row header is printed but not in the next new pages.

I will highly appreciate if someone could help me.

1
reporting-servicesssrs-2008ssrs-2008-r2ssrs-tablix
Please check this solution with all screenshots stackoverflow.com/questions/16701486/… – Ravi Matani
@ravi I have done the same as your link explains but it is not working for me. I have to say that my second row is a subreport thati contains a chart. I have edited the original post. – Ralph
@ravi If I insert a new row above the table header and delete the old header row it "works", I mean, it partially works, when I export to PDF it is working ok, well formatted into PDF, but from SSDT preview tab it is not showing correctly. Why? – Ralph

1 Answers

2
votes

Set the RepeatOnNewPage property instead:

  • Go to View and enable the Properties pane.
  • Click on the Tablix and and toggle Advanced Mode. (Using the arrow to the right of the Column Groups label.)
  • Click through the row groups named "Static" until you find the one corresponding to the row you want to appear on each page.
  • In the Properties pane under Other group, set the RepeatOnNewPage property to "true".