How to refresh amount of variable??

[sepideh06]

Hello,
I have a problem......i sent 2 datasets to my report....and one of them is grouped by the other.........i try to explain the shape of it....

AccountCode1
then all recordes related to this code
------------------------------
------------------------------
------------------------------
--------(here is sum of the one column)

AccountCode2
and then all recordes related to this code
----------------------------
----------------------------
---------------------------
--------(here is sum of the one column)

but it is needed that this sum goes to first of the next page.....so i defined a public variable as the name of (sum1)
and put it in a ColumnHeaderband above my databand.......and it is computed as (sum1 = sum1 + tbl1.Document_salary;)in BeforePrinet Event of databand......and it is shown in Columnheadband as (Text36.TextValue = (sum1-tbl1.Document_Salary).ToString();).....................it works completely true but it has one problem and it is that the amount of sum isn't refreshed for AccountCode2 and it is sumed with previuse amounts....i don't know how i can refresh it at the first of every Account Code.
thanks for your attentions

[Alex K.]

Hello,

Please send us your .MRT file with database for analysis on support@stimulsoft.com

Thank you.