I have a similar situation... but my problem is that.. when I used this code.... the running total is fine.. but when this total is put in group footer... it add the last records value one more time in the final total...

Means, if the records are:

200
300
400

So, the total should be 900. But it calculates 1300 (adding 400) one more time.. when I put the field in group footer section.

My code is something exactly like:


numberVar Opening Balance;

IF OnFirstRecord THEN
Opening Balance := {RPT_DP_CUSTOMER_STMT_SP.CLEARED_BAL}+{RPT_DP_CUSTOMER_STMT_SP.TOTAL_DR_AMT}-{RPT_DP_CUSTOMER_STMT_SP.TOTAL_CR_AMT};

ELSE
Opening Balance:= Opening Balance+ [CR_AMT- DR_AMT]



Can you help?


Edited by komail - 20 Jul 2011 at 12:07pm