[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1640
  • Last Modified:

SSRS 2008R2: Column headers are not displaying after the first page

Hi All

I have an SSRS 2008R2 report that works fine, except I have three column header-rows that I need to display on all printed pages, and right now it only displays on the first page in both the designer-Preview tab and when run in the report portal.  columnn-headers-q-tablix.jpgI am setting the Tablix properties, Column headers 'Repeat header columns on each page' checkbox...columnn-headers-q-tablix-propert.jpg... but the column headers do not render after page 1.

Any help other than 'here's a link, now you figure it out' would be appreciated.

Thanks in advance.
Jim
0
Jim Horn
Asked:
Jim Horn
  • 2
1 Solution
 
ValentinoVBI ConsultantCommented:
Hi Jim,

As you've discovered, headers can be tricky and even more so when the tablix has got a group (when doesn't it, right?).

Here's how you can get those headers displayed on all pages:

With your tablix selected, activate the Advanced mode for the Row/Column Groups.  That can be done using the little dropdown icon to the right of the Column Groups "header".  The first three items in your Row Groups pane should now be grey (Static) items.  These represent your three header rows.  Select the first one by clicking it and set the following properties:

RepeatOnNewPage = True
KeepWithGroup = After

Repeat this for the other two rows.

The KeepWithGroup setting might not be needed but in some cases it is.  I don't know why, I would think setting RepeatOnNewPage to true would be sufficient in all cases but for some reason it is not...

Valentino.
0
 
Jim HornMicrosoft SQL Server Developer, Architect, and AuthorAuthor Commented:
Perfect.  Thank you VV.

>activate the Advanced mode for the Row/Column Groups.
There are many times within SSIS and SSRS that I've had to edit basic (or what I think would be basic) properties by going into Advanced Mode / Advanced properties.

Makes me wonder what the dividing line between basic and advanced was in the eyes of the designers.
0
 
ValentinoVBI ConsultantCommented:
Glad to hear I could help you out! :)

VV
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now