I have create a bank.dbf with field 1. Bankname 2. DDNo 3. DDamount and i have create a "Bankwise report" in report designer. I want to put total in every pages based on DDamount field, so I have create a vaiable "Total" and put it is in the group footer region. suppose the report having more than one page i want to carry forward previous page total and sum current page ddamount and it is put in the above total vaiable in Group footer region.

How to do this in report designer?