Solved

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

Posted on 2013-11-19
3
1,490 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
  • 2
3 Comments
 
LVL 37

Accepted Solution

by:
ValentinoV earned 500 total points
Comment Utility
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
Comment Utility
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
Comment Utility
Glad to hear I could help you out! :)

VV
0

Featured Post

How to run any project with ease

Manage projects of all sizes how you want. Great for personal to-do lists, project milestones, team priorities and launch plans.
- Combine task lists, docs, spreadsheets, and chat in one
- View and edit from mobile/offline
- Cut down on emails

Join & Write a Comment

Here's a requirements document template for an integration project (also known as Extract-Transform-Load or ETL) based on my development experience as an SQL Server Information Services (SSIS) developer over the years.
For both online and offline retail, the cross-channel business is the most recent pattern in the B2C trade space.
Via a live example, show how to set up a backup for SQL Server using a Maintenance Plan and how to schedule the job into SQL Server Agent.
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

762 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now