How to get the page number and total pages in report body?

Question

How to get the page number and total pages in report body?

veeren4urs

SSCrazy

Points: 2763
More actions
March 5, 2010 at 11:42 am

#230587

Hi,
I want to use the page number and total pages in my Report body. can any body tell me how to achive this...
Thanks in advance...
Veeren
Thanks & Regards,
Veeren.
Ignore this if you feel i am Wrong. 😉

Viewing 6 posts - 1 through 5 (of 5 total)

You must be logged in to reply to this topic. Login to reply

Jack Corbett SSC Guru Points: 184394 More actions · Answer 1

I don't know of a way to do it in the report body because the PageNumber and TotalPages items are only allowed in a page footer or header. Why can't you use a Page Footer/Header?

Jack Corbett
Consultant - Straight Path Solutions
Check out these links on how to get faster and more accurate answers:
Forum Etiquette: How to post data/code on a forum to get the best help
Need an Answer? Actually, No ... You Need a Question

wendy elizabeth SSCoach Points: 16915 More actions · Answer 2

Here are some links you may want to refer to:

1. create table of contents and page numbers in SSrS2008

http://www.u2u.info/Blogs/U2U/Lists/Posts/Post.aspx?ID=10

setting up page numbers

2. Microsoft Dynamics NAV 2009 Reports: Pagenumbers x/y

3. allow user toset number of lines per page

http://msdn.microsoft.com/en-us/library/ms157328.aspx

4. http://www.infoq.com/articles/Gogolowicz-Swanson-SSRS

veeren4urs SSCrazy Points: 2763 More actions · Answer 3

Hi,

Friends, yes thats correct we cant use the pagenumber and totalpages in body.

Even i created one vbscript to get the total pages but its giving expected results...Anybody please let me know how ssrs page calculations stucture will be in ssrs i mean i just wondering why its not working in body...!

And my requirment is i need to show page number and the total pages inside the tablix of ssrs body

Thanks

Veeren.

Thanks & Regards,
Veeren.
Ignore this if you feel i am Wrong. 😉

Nandy Ten Centuries Points: 1016 More actions · Answer 4

Try with inbuilt expressions to get Total pages and page no

="Page " & Globals!PageNumber & " of " & Globals!TotalPages

veeren4urs SSCrazy Points: 2763 More actions · Answer 5

Hi Nandy,

We cant use page number and total pages in Report body.It will give error check it out.

Thanks

Veeren.

Thanks & Regards,
Veeren.
Ignore this if you feel i am Wrong. 😉