SSRS - Column headings don't display on subsequent pages

Question

Post reply

SSRS - Column headings don't display on subsequent pages

nano2nd

Hall of Fame

Points: 3073
More actions
December 1, 2010 at 12:44 pm

#229347

What property value do I need to set so that the header row I created displays on subsequent pages?

Viewing 15 posts - 1 through 15 (of 17 total)

You must be logged in to reply to this topic. Login to reply

andersg98 SSCertifiable Points: 5180 More actions · Answer 1

This link seems to instruct on how to "freeze" column headings on a report:

http://msdn.microsoft.com/en-us/library/bb934257(SQL.100).aspx

nano2nd Hall of Fame Points: 3073 More actions · Answer 2

I tried the solutions in the link but they didn't solve my problem. The link tells you how to keep the headers visible when scrolling through a long web page full of data. I am trying to get the header row to repeat on subsequent pages (across page breaks) so that I can print it.

mtillman-921105 SSCertifiable Points: 7156 More actions · Answer 3

It's easy to place the headers in the body of the report in SSRS. One solution is to place the headers in the header region if you can. (And the header region is what I'm used to thinking of as a Title region since I've used Crystal for so long.

The greatest enemy of knowledge is not ignorance, it is the illusion of knowledge. - Stephen Hawking

getoffmyfoot Hall of Fame Points: 3338 More actions · Answer 4

If you open up the properties of the tablix in your report in Report Builder, there is an option under General>"Repeate header rows on each page". There is also an option "Repeate header columns on each page". I believe that is what you are after.

nano2nd Hall of Fame Points: 3073 More actions · Answer 5

That was checked by default but the headers still don't display. Thanks.

nano2nd Hall of Fame Points: 3073 More actions · Answer 6

Perhaps I'm not describing my problem correctly. I've attached a screen shot of the report design. I need the titles in the sesction with the green background to repeat on each page.

MWise SSCarpal Tunnel Points: 4074 More actions · Answer 7

Check out: https://connect.microsoft.com/SQLServer/feedback/details/337720/katmai-reporting-services-2008-tablix-control-repeat-column-headers-does-not-work?wa=wsignin1.0

The steps in the 6th comment down posted by Will SQL worked for me.

nano2nd Hall of Fame Points: 3073 More actions · Answer 8

I was sure this would be the answer, but it didn't help. Thanks anyway

h_d_t Old Hand Points: 337 More actions · Answer 9

i've had this exact headache, and it really is a matter of ensuring:

a) the tablix properties, tick 'repeat header columns on each page', and 'repeat header rows on each page'.

b) go to advanced view (rather hidden, let me know if you aren't sure where to access it), select the topmost Static member and set 'RepeatOnNewPage' to True.

if the above does not work, then the tablix is 'corrupt', and you have to recreate it.

note however, if you export to Word, non of the above will work, as Word has a bug/feature and won't create the repeat of the headers. If you export to pdf you will actually see your repeating headers working as expected.

nano2nd Hall of Fame Points: 3073 More actions · Answer 10

I checked the Tablix properties again and both "Repeat Header Rows (and Columns) on each page are checked"

In advanced mode I can check "Repeat On New Page True" on the top static row group but if I check that option on the top static column group I gert an error:

Error1[rsInvalidRepeatOnNewPageOnColumnTablixMember] The tablix 'Tablix1' has an invalid TablixMember. All TablixMember elements in a TablixColumnHierarchy must have the RepeatOnNewPage property set to false.C:\Visual Studio\SPDW\ContractorTimeRpt\Hours By Division.rdl00

I can't come up with a combo that works.

h_d_t Old Hand Points: 337 More actions · Answer 11

quite a pain, but try recreating the tablix from scratch. when you play around with groupings etc, it gets 'confused', i've found.

nano2nd Hall of Fame Points: 3073 More actions · Answer 12

I know what you neam by confusion. I think SSIS has the same issue sometimes. I'll try to recreate the report today and let you know what I see.

ben_johns Valued Member Points: 71 More actions · Answer 13

h_d_t (12/5/2010)
i've had this exact headache, and it really is a matter of ensuring:
a) the tablix properties, tick 'repeat header columns on each page', and 'repeat header rows on each page'.
b) go to advanced view (rather hidden, let me know if you aren't sure where to access it), select the topmost Static member and set 'RepeatOnNewPage' to True.
if the above does not work, then the tablix is 'corrupt', and you have to recreate it.
note however, if you export to Word, non of the above will work, as Word has a bug/feature and won't create the repeat of the headers. If you export to pdf you will actually see your repeating headers working as expected.

Upgrading from 2008 to R2 has caused these issues with our reports. Your fix doesn't work for me, and I believe I have a 'corrupt' tablix. How do I go about recreating it (and it's groups)?

DB_Newbie2007 SSCarpal Tunnel Points: 4448 More actions · Answer 14

Even though this is an older post, some (like me) researching this might find this useful:

Apparently, setting the "Tablix properties" is only good for a Matrix and not a regular table. We also appear to be having a similar issue (no repeating Column Headers) in SQL 2012.

Argue for your limitations, and sure enough they're yours (Richard Bach, Illusions)