Solved

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

Posted on 2013-11-19
3
1,556 Views
Last Modified: 2016-02-11
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
Comment
Question by:Jim Horn
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 2
3 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
ID: 39661661
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
 
LVL 65

Author Closing Comment

by:Jim Horn
ID: 39662445
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
 
LVL 37

Expert Comment

by:ValentinoV
ID: 39662578
Glad to hear I could help you out! :)

VV
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Viewers will learn how the fundamental information of how to create a table.

738 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question