Click here to monitor SSC
SQLServerCentral is supported by Redgate
Log in  ::  Register  ::  Not logged in
Home       Members    Calendar    Who's On

Add to briefcase

Render to PDF Resets page number to 1 on every page, not just at group breaks Expand / Collapse
Posted Monday, July 7, 2014 10:04 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Wednesday, July 20, 2016 11:57 AM
Points: 29, Visits: 114
Hi All,

I'm having a rather strange problem. I've got a report that produces statements for a group of people. The report has a header with a text box that I conditionally suppress if the current page is greater than 1. I also have a group defined for each person (i.e. Jones, A, Smith A, etc.) with a page break between groupings with the Reset Page Number toggled to true. All of this works just fine when I run the report in Visual Studio 2010 and then save the report as a PDF. The text box in the header is displayed on the 1st page in for each group item and suppressed if there are multiple pages for each person.

However, when I deploy the report to the SSRS server (SQL 2008R2 w/SP2), run it, and save it as a PDF, the PDF renderer resets the page number to 1 for EVERY page (which then displays the header text on every page). The report is targeted to SQL 2008 R2 and later when it is deployed.

Any thoughts, helps, tips, etc. on how to resolve/fix this would be greatly appreciated.

Post #1589992
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse