Totals in Crystal Reports

Hello experts -

I am trying to insert a grand total that will total the formulas already inserted for each group.  For example, I have the following formulas in the corresponding sections:

Header

WhilePrintingRecords;
Global CurrencyVar TotalGift;
TotalGift:=0;

Detail

WhilePrintingRecords;
Global CurrencyVar TotalGift;
if (DistinctCount ({gifts_full.giftkey}, {names_VIEW_preferred.namesmashd})>1 and
{gifts_full.giftkey}=previous({gifts_full.giftkey}))
then 0
else
TotalGift := TotalGift + {gifts_full.giftjntamt}+0;

Footer

WhilePrintingRecords;
Global CurrencyVar TotalGift;
TotalGift

These totals are entered per constituent and I would like the grand total entered at the bottom of the report.  Is that possible?  I have attached the actual report as well.

Thank you.
Lisa
New-Major-Commitments.rpt
lcallah93Asked:
Who is Participating?
 
Ido MilletProfessor of MIS at Penn State Erie and Owner, Millet SoftwareCommented:
Just at a GrandTotalGift variable, accumulate it but DON'T reset it in the group headers.
0
 
lcallah93Author Commented:
THANK YOU!  I knew it was something I was overlooking.
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.