SQL Clone
SQLServerCentral is supported by Redgate
 
Log in  ::  Register  ::  Not logged in
 
 
 


Render to PDF Resets page number to 1 on every page, not just at group breaks


Render to PDF Resets page number to 1 on every page, not just at group breaks

Author
Message
jfuller 57139
jfuller 57139
Valued Member
Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)Valued Member (53 reputation)

Group: General Forum Members
Points: 53 Visits: 117
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!
Go


Permissions

You can't post new topics.
You can't post topic replies.
You can't post new polls.
You can't post replies to polls.
You can't edit your own topics.
You can't delete your own topics.
You can't edit other topics.
You can't delete other topics.
You can't edit your own posts.
You can't edit other posts.
You can't delete your own posts.
You can't delete other posts.
You can't post events.
You can't edit your own events.
You can't edit other events.
You can't delete your own events.
You can't delete other events.
You can't send private messages.
You can't send emails.
You can read topics.
You can't vote in polls.
You can't upload attachments.
You can download attachments.
You can't post HTML code.
You can't edit HTML code.
You can't post IFCode.
You can't post JavaScript.
You can post emoticons.
You can't post or upload images.

Select a forum

































































































































































SQLServerCentral


Search