Updating to SSRS 2008R2 from 2008 messed with report pagination

We have an application which produces a multi-categorical report as a PDF. Running SSRS 2008, the reports worked as designed. After upgrading SSRS to 2008R2, the pagination seemed to have changed.

The first page appears as designed, but when a category exceeds a single page, the page break occurs in the middle of a row header. Whats more is that the page's header/footer will only appear on the first page of a multi-page category.

What I've found in research is that there were many changes to pagination in SSRS 2008 from earlier versions. But going from 2008 to 2008R2, I've found little concerning page breaks or pagination.

What is causing these problems? What can I do to get the reports working as designed? (With headers/footers on every page, and page breaks occurring after row headers)

more ▼

asked Jul 25, 2012 at 01:31 PM in Default

avatar image

20 1 3 4

My colleague and I have contacted Microsoft with the issue and are working out a solution. Will post an answer once we find it!

Aug 06, 2012 at 02:12 PM bajohns
(comments are locked)
10|1200 characters needed characters left

1 answer: sort voted first

Since being in contact with a Microsoft rep. We've found out that further updating our SSRS with Service Pack 2 fixed this particular issue for us.

more ▼

answered Aug 21, 2012 at 12:45 PM

avatar image

20 1 3 4

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jul 25, 2012 at 01:31 PM

Seen: 1496 times

Last Updated: Aug 21, 2012 at 12:45 PM

Copyright 2018 Redgate Software. Privacy Policy