Groups | Blog | Home
all groups > sql server reporting services > march 2006 >

sql server reporting services : How can I retrieve the number of pages for a report in RS 2000?


Alan Juden
3/7/2006 11:25:21 AM
I need to retrieve the number of pages for a report in reporting services
2000. The reason that I'm doing this is because I'm accessing the report by
the Reporting Services web service and the toolbar doesn't come with the
report that way. So I'm basically making my own toolbar to display along
with the report. I'm working on the navigation part of the toolbar and I
can't find a way to get the number of pages that the report has. I know that
my problems would be solved if I switched to RS 2005 but that's not an option
right now. Thanks for the help.

allison
3/8/2006 6:18:27 AM
I have done it within a report using this code (actually counts number of
pages per group) however I'm not sure how you could embed it in your toolbar.

Shared offset as Integer
Public Function GrpPN(reset As Boolean, pagenumber As Integer) As Integer
If reset
offset = pagenumber - 1
End if
Return pagenumber - offset
End Function


--
Allison


[quoted text, click to view]
toolman
3/8/2006 2:41:59 PM
Are you not able to use the Globals!TotalPages report item?

[quoted text, click to view]
Alan Juden
3/9/2006 7:30:30 AM
I'm actually talking about in the web service not in the report. Thanks for
the replies though.

Alan


[quoted text, click to view]
AddThis Social Bookmark Button