x
login about faq Site discussion (meta-askssc)

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 '12 at 01:31 PM in Default

bajohns gravatar image

bajohns
20 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 '12 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 '12 at 12:45 PM

bajohns gravatar image

bajohns
20 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.

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



Facebook logo Follow Ask SSC on Facebook
Find Ask SSC on Google+
linkedin logo Find us on LinkedIn

Topics:

x95
x53
x20
x10
x5

asked: Jul 25 '12 at 01:31 PM

Seen: 479 times

Last Updated: Aug 21 '12 at 12:45 PM

Copyright © 2002-2012 Simple Talk Publishing. All Rights Reserved. If you have any queries, please contact the site administrators.
Ask SQL Server Central is a community service provided by Red Gate.