Crystal Reports-Multiple lines

Karen Couch

I'm creating a payment by year report for pledge. Several individual have paid more than the installment amount (example: $100,000 per year for 5 years due 12/21-12/25 - their payment was $500,000 paying all installments). However, on the report it shows $500,000 5 times rather than one payment of $500,000. I've even tried making 5 $100,00 payments but nothing will fix the outcome of 5 - $500,000 payments. I'm grouping on GFCNBioIDKey and GfIns_1PY1IDKEY. I need the payment of $500,00 to show up once in 2021. Please help

Marie Stark

Is your data in the detail section or in the group footer?