Passing a value to a GroupFooter - Crystal Rpt 8

[SGIORDANO]

I have a formula in the groupfooter which is calculating a percentage.

I am passing the value from a VB Form where I am comparing this value with a formula in the record selection. It is telling me 'THIS FORMULA CANNOT BE USED BECAUSE IT MUST BE EVALUATED AFTER'

I have also tried the GROUP_SELECTION but for no use.

What can I do to solve this problem?

Your help will be appriciated
Steve

 

[dgillz]

Please post the formula that you are getting this message on. Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[SGIORDANO]

WhilePrintingRecords;

NumberVar intSpendVel;
StringVar StrSpendVel;


If {VIEW_AUTH_SPENDING_VEL_RPT.PERIOD_AMOUNT_LIMIT} <> 0 then (
intSpendVel:= (Sum ({VIEW_AUTH_SPENDING_VEL_RPT.ACCOUNT_AMOUNT_NET}, {VIEW_AUTH_SPENDING_VEL_RPT.CARD_NUMBER})
/{VIEW_AUTH_SPENDING_VEL_RPT.PERIOD_AMOUNT_LIMIT}) * 100;
StrSpendVel := ToText(intSpendVel)+'%';
StrSpendVel)
else
StrSpendVel := 'N/A';

-----
When I try to get the intSpendVel value passed from the Form it will tell me 'THIS FORMULA CANNOT BE USED BECAUSE IT MUST BE EVALUATED AFTER'

Thank You
Steve

 

[dgillz]

Is this formula in the details section of your report? If not what section is it in? Software Training and Support for Macola, Crystal Reports and Goldmine
714-348-0964
dgilsdorf@mchsi.com

 

[SGIORDANO]

No it is in a Group Footer. That is basically the problem as it something that is calculated after the details have passed the values to it.

Thanks
Steve