How to refresh amount of variable??
Posted: Tue Oct 19, 2010 5:04 am
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
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