Category Archives: SSRS

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.

Unable to subscribe to a report in SSRS

In some cases you are not allowed to subscribe to a report (have it send schedullled to you). The reason for this is logical but well hidden for us mere mortals. It took me a while to find it so here it is.

You cannot subscribe to a Report Builder report that uses a model as a data source if the model contains model item security settings. Only reports that use model item security are included in this restriction.

 For more information: