?
Solved

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

Posted on 2013-11-19
3
Medium Priority
?
1,612 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 2000 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 66

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

Windows Server 2016: All you need to know

Learn about Hyper-V features that increase functionality and usability of Microsoft Windows Server 2016. Also, throughout this eBook, you’ll find some basic PowerShell examples that will help you leverage the scripts in your environments!

Question has a verified solution.

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

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…
A Stored Procedure in Microsoft SQL Server is a powerful feature that it can be used to execute the Data Manipulation Language (DML) or Data Definition Language (DDL). Depending on business requirements, a single Stored Procedure can return differe…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.
Suggested Courses

800 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