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