Charting on Print Time Formula where formula resides in Report Footer

[gillonia]

Using CR 9 against an Oracle DB

Ok, I know that the cr9_charting_print_time_formulas.pdf details the process for doing this but I still can't get this working... :-( I'm still relatively new to Crystal so apologies in advance if this is obvious to others.

I'm trying to pass a datetime value and a number value (in the format:
JUN 99.84 (ie Month of June - 99.84% availability)

over to my sub-report to chart on, but I'm not getting the correct value. What I'm getting is 100 which appears to be the value if this is in the detail section (ie initial value) rather than the value where it does reside - the footer.

The number value is calculated as the formula @Availability Current Month :

({@Annual Actual}/{@Annual Prime})*100

where @Annual Actual:

"WhilePrintingRecords;
Shared numberVar Act_Ann;

IF ({AVAILABILITY_PRIME.AVAIL_DATE} > (DateAdd("m",-12,{?Target Date}) - 1)
AND {AVAILABILITY_PRIME.AVAIL_DATE} <= {?Target Date} )
THEN Act_Ann := Act_Ann + {@Actual to Num}
ELSE Act_Ann;
Act_Ann"

and @Annual Prime:

"WhilePrintingRecords;
Shared numberVar Pri_Ann;

IF ({AVAILABILITY_PRIME.AVAIL_DATE} > (DateAdd("m",-12,{?Target Date}) - 1)
AND {AVAILABILITY_PRIME.AVAIL_DATE} <= {?Target Date} )
THEN Pri_Ann := Pri_Ann + {@Prime To Num}
ELSE Pri_Ann;
Pri_Ann"

Thanks in advance for any advice.