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 ««12

Page numbers in SSRS while exporting to pdf file Expand / Collapse
Author
Message
Posted Tuesday, October 13, 2009 8:07 AM
Grasshopper

GrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopperGrasshopper

Group: General Forum Members
Last Login: Tuesday, April 29, 2014 6:13 AM
Points: 11, Visits: 409
I don't believe you can include global variables, like page number in a table footer. SSRS does not apper to allow you to start page numbering based on anything like a group by grouping in the header or footer.
Post #802157
Posted Thursday, October 15, 2009 2:26 PM
SSC Eights!

SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!SSC Eights!

Group: General Forum Members
Last Login: Yesterday @ 10:19 AM
Points: 891, Visits: 1,739
I had also similar problem before. the problem was that the form was expanding beyond the lay out of the report.
Go to project -> Report -> layout.
Make sure the form is trimmed to the boarder of the report lay out.
Post #803755
Posted Friday, October 16, 2009 9:00 AM
Valued Member

Valued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued MemberValued Member

Group: General Forum Members
Last Login: Tuesday, June 24, 2014 10:37 AM
Points: 62, Visits: 273
Try this

Expression for the page numbering...
="Page " & Code.GetPN(Not(ReportItems!tag.value Is Nothing),Globals!PageNumber)

Code for the page numbering...
Shared offset as integer
Public Function GetPN(reset As Boolean,pagenumber As Integer) as Integer
If reset
offset = pagenumber - 1
End If
Return pagenumber - offset
End Function
Post #804278
Posted Monday, April 28, 2014 4:11 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 29, 2014 4:13 AM
Points: 2, Visits: 4
Put a text box in Header/Footer or wherever you want and in the expression write this, =IIF(Globals!PageNumber = 1, "1", cStr(Globals!PageNumber)) it will show the page number and you can place another textbox before this as label saying Page:
Post #1565493
Posted Tuesday, April 29, 2014 2:57 AM
SSC Rookie

SSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC RookieSSC Rookie

Group: General Forum Members
Last Login: Yesterday @ 4:09 AM
Points: 36, Visits: 355
As i read your question i found that you have page size problem with SSRS view and PDF view. Please check Page size property for both or you can check it in Printer property(for which is default paper size of default printer).
Post #1565810
Posted Tuesday, April 29, 2014 4:13 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Tuesday, April 29, 2014 4:13 AM
Points: 2, Visits: 4
Go to report properties and set all margins to 0 and the PDF problem will be resolved.
Post #1565833
« Prev Topic | Next Topic »

Add to briefcase ««12

Permissions Expand / Collapse