Reporting Services Globals!PageNumber and Globals!TotalPages Reset

• SSSolice

  SSCommitted

  Points: 1907

  More actions

  April 16, 2009 at 10:59 am

  #202085

  Is there a way to reset the Globals!PageNumber and Globals!TotalPages on the change a report group?

  For example: When my report group "Region" changes from Atlanta to Jacksonville the page number and total pages would reset. Even if it could reset for the page number only, that would be good.

  Thanks.

• rdrag

  SSC Enthusiast

  Points: 143

  More actions

  May 11, 2009 at 2:25 pm

  #992449

  I found this post on how to get page numbers by group.

  http://blogs.msdn.com/chrishays/archive/2006/01/05/ResetPageNumberOnGroup.aspx

  However, I wanted the format "page x of x". This example doesn't handle that, and I don't know that it's possible. :sick:

• SSSolice

  SSCommitted

  Points: 1907

  More actions

  May 11, 2009 at 3:04 pm

  #992485

  Thanks a bunch for the link. I'll check it out. Cheers.