x

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

bajohns gravatar image

bajohns
20 1 1 1

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

bajohns gravatar image

bajohns
20 1 1 1

(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.

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x113
x84
x24
x11
x5

asked: Jul 25, 2012 at 01:31 PM

Seen: 1203 times

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