Trouble with resetting conditional running totals

[TerriO]

EVALUATE
I am having trouble resetting the conditional running totals for my report for my groups. Its only giving me the total for the page and not the entire group.

Below is what I am using for my conditional running total
EVALUATE
WhilePrintingRecords;
CurrencyVar RunningTotal;
If (OnFirstRecord or {V_UNION_ALL_LOANS.LOAN_ID} <> Previous({V_UNION_ALL_LOANS.LOAN_ID})) then
RunningTotal := RunningTotal +
{V_UNION_ALL_LOANS.LOAN_AMOUNT}

Initialize GH
whileprintingrecords;
currencyvar runningtotal := 0

display DETAILS
WhilePrintingRecords;
CurrencyVar runningtotal ; Terri Mimbs

 

[dgillz]

If you are repeating the group header at the top of each page, which mny users request for readability, this is exactly what WILL happen. A group header comes along a reinitializes the variable. To get arouind this, change your Initilize GH formula to:

Not OnRepeatedGroupHeader
whileprintingrecords;
currencyvar runningtotal := 0



Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com

 

[TerriO]

Thanks, that seems like the logical thing to do and I never would have noticed that, but I keep getting the error
&quot;A number, currency amount, boolean, date, time, date-time, or string is expected here&quot; I have tried to manipulate the initialize several different ways and the error keeps coming up.
Terri Mimbs

 

[goranm]

Hi !

Try &quot;InRepeatedGroupHeader&quot;
(instead of &quot;OnRepeatedGroupHeader&quot

/Goran

 

[dgillz]

I stand corrected Software Support for Macola, Crystal Reports and Goldmine
dgillz@juno.com