Repeat Row Header on each page Unique situation I promise!

  • So I'm working on a report for an educational institution with SSRS 2008

    Printing Course Schedules for students.

    I am using a table to display the Course schedule header, student name, school year etc.

    I am using another table nested within a subgroup row to show the actual courses listed for each semester using a pivot structure to keep even numbered semesters on the right and odd on the left. So the problem is that when the "subtable" extends over the boundary of the page I need the Student header information to repeat. This is not happening and I think it is because the row is continuing rather than it being recognized as the parent table repeating.

    thoughts how I might overcome this

    I've added a snip from BIDS to illustrate what I'm talking about.

  • I have found SSRS 2008 to be pretty flakey with regard to repeating headers.

    To make sure the basics are covered. In the grouping pane (default is a thin horizontal pane just below the main design pane) there is a small drop down arrow on the right side. Click the arrow and choose advanced. That should show you all the rows in your design under the row groups pane. Highlight the likely suspect and go to properties and choose RepeatOnNewPage = True.

    I also find it very useful to make this setting very early on in the design process because I believe it is more likely to work, and keep working when I do it early.

    Good luck.

  • Yep, did that stuff

    I think it has to do with the second subtable this is the part that forces the page break so its headers will repeat but the row above with the student information will not.

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply