Solved

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

Posted on 2013-11-19
3
1,518 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
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

Simplifying Server Workload Migrations

This use case outlines the migration challenges that organizations face and how the Acronis AnyData Engine supports physical-to-physical (P2P), physical-to-virtual (P2V), virtual to physical (V2P), and cross-virtual (V2V) migration scenarios to address these challenges.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
View SQL 2005 Job package 16 43
create an aggregate function 9 34
Passing Parameter to Stored Procedure 4 24
SQL Server Import/Error Wizard error 12 19
Why is this different from all of the other step by step guides?  Because I make a living as a DBA and not as a writer and I lived through this experience. Defining the name: When I talk to people they say different names on this subject stuff l…
From implementing a password expiration date, to datatype conversions and file export options, these are some useful settings I've found in Jasper Server.
Using examples as well as descriptions, and references to Books Online, show the different Recovery Models available in SQL Server and explain, as well as show how full, differential and transaction log backups are performed
Using examples as well as descriptions, and references to Books Online, show the documentation available for datatypes, explain the available data types and show how data can be passed into and out of variables.

777 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