Getting Database Total while using Sort

[davidmo]

I working with a database of open invoices. I use the Select Expert to show customers who have either paid their invoices or we have written off for the week. At the report footer I have the sum of amount Paid in one column and amount Written Off in another. What I would like is to show the sum of all Open Invoices for the entire database next to the two other sums. Any ideas

 

[dgillz]

You would need an unlinked subreport for this. Take you current report, modify the report to show all unpaid invoices. Save it as another name and insert it as a subreport.

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports

http://www.trianglepartners.com

dgilsdorf@trianglepartners.com