Hi,

I'm using cr 2008 and am trying to get a running total going in my report but it is not working as expected.
All the formulas are on the main report (no subreports).
I have a formula in the page header like so:

Global NumberVar x;
x := {auarstmh.bal_opn}

This displays the correct value from auarstmh.bal_opn on the report.

In the details section I have this:

Global NumberVar x;
x := x + {auarstmw.trn_val}

Which doesn't display the correct values.   auarstmw.trn_val is a field in the details section.

For example on one report the values are:

Report Header
auarstmh.bal_opn formula = 4063.70

Details
auarstmw.trn_val = 5.30
formula = 1637.40 (according to my formula this should be 4063.70 + 5.30 = 4069.00)
-----------------------------------------
Another example with two detail records:

Report Header
auarstmh.bal_opn formula = 1798.20

Details
auarstmw.trn_val = 26.50
formula = -3279.54 (according to my formula this should be 1798.20 + 26.50 = 1824.70)

auarstmw.trn_val = 54.60
formula = 1852.80 (according to my formula this should be 1824.70 + 54.60 = 1879.30)

I hope I have made this clear enough.  It seems it must be a simple mistake I am making as it doesn't look hard at all!

thanks in advance

justin

Thanks for the reply lockwell.

I have checked the suppressed records suggestion but from looking directly at the tables the data is being pulled from, there are no records being suppressed.

I'll try the suggestion of shifting the page header formula to different areas and see if that helps.

justin