I created an outstanding invoices report in Crystal Reports 2008. The data is pulled from an Access database.
I have a formula that calculates the remaining amount for each OPEN contract. In order for that formula to work I had to have all invoices included in the report. Then I used if then else statements to make it so that the entire row would be "blank" for each invoice that has been paid. I then used the Section Expert (by right clicking on Details in design view) to "Suppress Blank Sections."
The report is now how I want it except for TOTALS.
I want a grand total for remaining amounts and a grand total for unpaid invoices.
I cannot use a "summary" to sum either of them up because of how the report was created.
Is there another way for me to total these two columns? If so, how?
Thank you in advance for your time.