Getting SSRS Page Header to repeat

  • Does anyone know where I can configure the properties so the page header grouping returns on every single page of the report even though the data is the same for the header? I have reports where I'm using data for a Division and Department for the page headers. The Division is the same throughout the report but it goes blank after the first page. The departments change and those display but the division disappears after the first page. I can't find where I can get the main header for the division to be visible throughout the report.

    Can anyone help?

    Thanks!

  • There is a pane just under the main design pain, I believe it is called the grouping pane. On the right is a down triangle, click it and choose advanced mode and it will reveal all the rows in your report. Select the appropriate row, go to properties, and choose RepeatOnNewPage.

    I use this all the time, however I have found it to be very flakey in 2008. If you delete a column or row after making this setting it frequently won't work no matter what you do. I also find it best to make this setting very early in report design because it frequently does not work as expected after a number of groups have been set up and edited.

    Hope this helps. Good luck.

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

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