How to get total pages based on grouping and reset in SSRS 2005?

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • Brian Connelly
    New Member
    • Jan 2011
    • 103

    How to get total pages based on grouping and reset in SSRS 2005?

    I have this code that I used to reset the page numbers based on the grouping value change and it executes as it should.
    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 = 1
      Else 
      offset = offset + 1
    
      End If
      Return offset
    
    End Function
    However, I need to now calculate the total pages per each group and have no idea how to do this. An examp would be page 1 of three for the first group page footer and page 1 of 2 for the second group because the page rendering will be dynamic based on the amount of information returned for each group. Any ideas or help would be greatly appreciated.
  • Brian Connelly
    New Member
    • Jan 2011
    • 103

    #2
    I should mentioned that the function is actually wrote as Public Function GetGroupPageNum ber(group as Object) as Object

    Comment

    Working...