Total number across multiple pages

• dpsql

  SSChasing Mays

  Points: 653

  More actions

  April 18, 2016 at 2:47 pm

  #315714

  Hello,

  I am trying to get a total amount across multiple pages.

  Lets say my total for page 1 is 120, page 2 is 200, page 3 is 150. These numbers are in my footer next to the page number. Is there a way to put that total amount in a header on page one?

  My header will say something like "Total Count = 470".

  Thanks

  DP

• sharonsql2013

  SSCertifiable

  Points: 5908

  More actions

  April 20, 2016 at 8:41 am

  #1873360

  If you are getting the total in a table then try adding a text box in a footer and reference the value in that table cell.

  Example.

  =Reportitems!Textbox6.value