Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
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
Author
Message
Posted Monday, July 7, 2014 10:04 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, September 30, 2014 7:43 AM
Points: 18, Visits: 72
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.

Thanks!
Post #1589992
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse