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
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
Off the top of my head I can't think of a way to do this.
Is each group on a single page?
mlmcc