tags:

views:

16

answers:

2
Q: 

Report Headers not repeating on random pages in SSRS 2008 when exporting to PDF

I am writing a report in SSRS 2008 that has the following advanced layout:

Static
Static
Static
Static
Group1
Details
Static
Static

The settings for the top 4 static rows (which are my headers) are set to RepeatOnNewPage = true, FixedData = true, and KeepWithGroup = After. When viewing the report through SSRS or through VS, the headers repeat correctly on every page. However when the report is exported to PDF, on some report requests, random pages seem to be missing the headers.

Example: - Report has 5 pages, headers are missing on page 2/5 but on every other page they should be on.

I've exhausted the Googles, the tubes, and StackOverflow looking for an answer but I have yet to find anything. HALP.

A: 

Have you tried putting your static headers into the report Page Header section?

Mark Bannister  2010-08-31 15:42:39
Unfortunately alot of the headers are nested in odd places in the reports I am working on and this is not possible all the time. I know this will work as a work around, I was just curious if there is a patch or any more information related to the random repeating I am seeing. Thanks for the idea though, I'm more than likely going to have to do something like that.
JeffryEngberg  2010-09-01 06:18:50
A: 

There is a known bug in 2008 for report headers not repeating. Not sure if it exists in R2 but heres a link that might help.

http://www.bidn.com/blogs/ChrisAlbrektson/bidn-blog/956/repeating-column-headers-in-ssrs-2008-and-r2

 2010-08-31 19:01:20
Thanks for the info. Unfortunately what they are suggesting in the link is essentially what I have been doing so far. I've suggested to our group that we give R2 a try to see what happens, I'll follow up if that works!
JeffryEngberg  2010-09-01 06:31:35

related questions

Strip HTML from string in SSRS 2005 (VB.NET)
SQL Server 2008 Reporting Services Control
How do I resolve a System.Security.SecurityException with custom code in SSRS?
Sending e-mail from a Custom SQL Server Reporting Services Delivery Extension
How to aggregate data from SQL Server 2005
Is there a Box Plot graph avalible for Reporting Services 2005?
How do I set a textbox to multi-line in SSRS?
SQL 2005 Reporting Services custom report item (CRI) - what are the limits?
SQL Reporting Services viewer for webpage - can you move the View Report button?
Custom font in SQL Server 2005 Reporting Services
I can share a SQL Server Reporting Services Data SOURCE... what about a Data SET?
Enterprise Reporting Solutions
Internationalization in SSRS
Easy way for Crystal Reports to MS SQL Server Reporting Services conversion
SSRS - Post Publishing Tasks
SSRS - Process dies/goes to sleep after not being used
SSRS - RSS Feeds
SSRS - Uninstall Trial Version of VS Business Intelligence
Optimizing the PDF Export of Huge Reports in Sql Reporting Services 2005
SSRS scheduled reports not working.
Using Parameters in MS Reporting Services (SQL 2008) against an ODBC data source
Conditional Visibility and Page Breaks with SQL Server 2005 Reporting Services
How do you handle audit logging with SSRS?
Reading recommendations for: SQL Server 2005 Reporting Services
How can I dynamically center an image in a MS Reporting Services report?