asked on

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?

Mike McCracken

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

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

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

SOLUTION

James0628

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial