Reset Total page number in a group
I know how to reset the page numbers with each group, but how do you reset the total page number within each group.
EX. Code for page of total pages
="Page " & Globals.PageNumber & " of " & Globals.TotalPages
EX. Code to reset within a group
Custom Code:
Shared offset as Integer
Shared currentgroup as object
Public Function GetGroupPageNumber(group as Object, pagenumber as Integer) as Object
If not (group = currentgroup)
offset = pagenumber - 1
currentgroup= group
end if
return pagenumber - offset
end function
=Code.GetGroupPageNumber(ReportItems!Category.Value(grouping),Globals!PageNumber)
What I need is code for a combination of the two...to display code for page of total pages that resets within a group.
Any help is greatly appreciated.
Thanks!
September 26th, 2006 9:43pm
Hello,
I am facing the exact same need. Anyone solve this?
Free Windows Admin Tool Kit Click here and download it now
January 19th, 2007 9:00pm
Same problem.
Is there any solution to reset the total page no?
December 6th, 2010 12:03pm
What version of SSRS are you using..
In SSRS 2008 R2 there is an in-built option to reset page number.. but not sure about the total pages function..
Free Windows Admin Tool Kit Click here and download it now
December 7th, 2010 1:45am
Same Problem, If i could find out how many rows are displaying withing a scope (ie. Tablix1) on a page i'd be able to work out the rest.
May 17th, 2011 6:33pm