Report Builder: Repeat row on every new page when using list

[kd_61]

Is is possible to repeat a row at the top of evey page when you are using a list, or are repeating rows only supported with tables and matrixes?

[kd_61 · Accepted solution]

Thank you for posting the helpful screen shots. It looks like RepeatOnNewPage does not work in cases where the group spans multiple pages.  I got around this constraint by using the page header, which does repeat. I added a hidden column to my list (tablix) whose value was the data that I wanted to repeat on every page. Then I inserted a textbox in the page header, and set the value to equal the hidden column.

[d_gosbell]

Lists, Tables and Matrixes all use the same underlying tablix control so yes this is possible. A list is effectively just a single column table. 

To configure this you would have to right click on the row header and add a new row outside the group and above the current row.

Then you need to turn on the Advance properties for the row and column groups as in the screenshot below so that you can see the new static Row Group which you just created.

Then you would want to turn on the Properties pane in the "View" ribbon and click on the "(Static)" row group. Then change the RepeatOnNewPage property to true

Now the content of that header row will be repeated on every page.