Custom Code

• fliu2265

  SSC Eights!

  Points: 818

  More actions

  September 22, 2016 at 4:29 pm

  #330481

  Hello,

  I need some help for a issue regarding custom code in SSRS.

  Below is the codes.

  ***********************************

  dim public totalCO as Decimal = 0

  Public Function AddTotal(ByVal textbox42 AS Decimal ) AS Decimal

  totalCO = totalCO + textbox42

  return textbox42

  End Function

  Public Function GetTotal()

  return totalCO

  End Function

  **************************

  In the group footer, I called =code.GetTotal() to get the sum for the group

  If report of each group is only fit into just one page. I can get correct sum value.

  However, the problem is it looks like totalCO is page specific, meaning it gets re-initialized each time when the page is changed (if reports have more than two pages).

  Thanks

  Frank

• Spiff

  SSCertifiable

  Points: 7766

  More actions

  September 23, 2016 at 2:24 am

  #1902722

  Hi Frank,

  Could this not be achieved using a RunningValue aggregation instead of custom code?

  If it's in the group footer you can just add the summed value each time e.g.

  =RunningValue(Sum(Fields!CO.Value), Sum, Nothing))