>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?
Double-click on the field you put in the group footer or page footer, and look at the options for "Calculation". Specifically, you may want to "Sum", and to reset only at the end of the report.
For some complicated reporting stuff you may need report variables, but here it doesn't seem necessary.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)