Post reply

Repeating row headers on each page

  • August 11, 2011 at 11:08 am

    #246182

    Hi, perhaps someone can explain what is going on here.

    I have created an inventory report of SQL Server instances in the environment. (See attachment)

    Problem is that the header row does not appear at the top of each page. From reading some articles, it looks like it has to do with the grouping (static and groups) but I don't know how to fix the issue. It seems like SSRS does not realize that the row in blue is a header.

    Can anyone tell what needs to be adjusted by looking at the image in the attachment?

    Thanks much,

    Howard

  • August 11, 2011 at 1:16 pm

    #1367527

    In row groups sector, click on the top one static and in properties window change value for RepeatOnNewPage property to True

  • August 11, 2011 at 2:44 pm

    #1367585

    Thanks for responding. Unfortunately, changing the very top Static to RepeatOnNewPage = True does not cause my header row to repeat on new pages. When I advance to page two, there is no header.

  • August 15, 2011 at 10:51 am

    #1368736

    You could try adding a page header and moving the text values to the page header, but it can be difficult to line everything up then

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

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