How to get SSRS to repeat the row headers (Tablix 2008)


Getting SSRS in SQL 2008 to repeat the headers on every page can be a time consuming task. Especially since the Tablix property window lets you set the checkboxes to repeat the Row and or Column headers. Nothing happens however if you set them.

You will have to digg into the Advanced settings at group level in order to make the headers repeat on all pages. The image below shows how to access the advanced settings in the group.

 

After turning on the Advanced Mode the region in the designer will show additional info and allows you to set the right values to get repeating headers: See the image below

If you ommit these settings on the static row the preview will give you an error. So after setting these values there is one more thing to do and that is set the property on the Details row as shown below:

This will do the trick for you and SSRS will now reproduce the headers on each page of the report.

About these ads

17 responses to “How to get SSRS to repeat the row headers (Tablix 2008)

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

Follow

Get every new post delivered to your Inbox.

Join 1,402 other followers

%d bloggers like this: