Friday, July 30, 2010

Tablix headers not repeating in SSRS 2008

The "Repeat header rows on each page" tablix property does not work in SSRS 2008 but works on SSRS 2005. This is clearly a bug and very annoying.
To turn this functionality on:
there is a small down arrow (not the down arrow on the group bar). Clicking that arrow will allow you to view advanced properties. When you select advanced properties you will see your groups in orange bars and the static rows in gray.
Set the KeepWithGroup property in the following way:
  • For a static row that is above a group, click After.
  • For a static row that is below a group, click Before.
If the above does not work then check the number of static rows above the Details group. Make sure that there are EXACTLY same number of the static rows. This nomally happens when you happen to delete a row(s) or grouping from the tablix.  If the number of static rows does not match, then re-create the tablix from scratch.

No comments: