SSRS Expression- Adding Totals per page

• reportingservices 2925

  SSC Enthusiast

  Points: 119

  More actions

  March 8, 2015 at 11:21 am

  #305589

  Hello Everyone,

  I need an expression to add a total per page in SSRS in the footer of the report. See screenshot.

  So when users run SSRS, the first page must show a total for order qty , ship qty and subtotal for the first page only.

  When users go to the second page, the it must show the total for order qty, ship qty and subtotal for the second page only as in the screenshot below.

  The data region that is being used is a table region, and on the footer textboxes are being used to add totals for order qty, ship qty and subtotal.

  Let me know if there is any expression that can do that and how I would add it to the footer. I thank you all in advance for helping !!

• HS_12

  Old Hand

  Points: 382

  More actions

  March 26, 2015 at 5:29 am

  #1786504

  Hi,

  You can add a textbox in the page footer and specify the value expression with ReportItems collection like below:

  ="Total" & " " & Sum(ReportItems!OrderQty.value)