Show formula in Page Header based on total in Group Footer

I am trying to create a Crystal Report where a formula in the Page Header is determined by the whether or not the total in the group footer is less than or greater than zero.

How can I get this done?

Crystal Reports

Last Comment

James0628

8/22/2022 - Mon

Mike McCracken

6/9/2015

What formula is used for the group footer total?

Off the top of my head I can't think of a way to do this.

Is each group on a single page?

mlmcc

MISSSB

6/9/2015

ASKER

My report has three groups.

In group footer 3 I have a formula called CalcAmt with this content:
if {v_payment_info.fund_code}="LV" then {cn_c3_reported.emp_levy_amt_calc} + {cn_c3_reported.emp_levy_penalty_amt}
else if {v_payment_info.fund_code}="SS" then {cn_c3_reported.emp_ss_amt_calc} + {cn_c3_reported.emp_ss_fines_due}
else if {v_payment_info.fund_code}="PE" then {cn_c3_reported.emp_pe_amt_calc} + {cn_c3_reported.emp_pe_penalty_amt}

Also in that group footer I have another formula called Pay_Diff with the following:
{@CalcAmt}-Sum ({v_payment_info.payment_amount}, {v_payment_info.fund_code})

In group footer 1, I have a formula called BalTotal that does the the following:
WhilePrintingRecords;
Numbervar dSum; //Don't initialize zero
dSum;

In the header I want to suppress a text box if the BalTotal formula returns 0

ASKER CERTIFIED SOLUTION

Mike McCracken

6/9/2015

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.

View this solution by signing up for a free trial.

Members can start a 7-Day free trial and enjoy unlimited access to the platform.

See Pricing Options

Start Free Trial

GET A PERSONALIZED SOLUTION

Ask your own question & get feedback from real experts

Find out why thousands trust the EE community with their toughest problems.

SOLUTION