I'm using Crystal 10 and I have a report that shows invoices due and totals them up. In the case of a duplicate invoice number is supresses the record but it still counts the supressed record in the total. How can I make the total not count the supressed records? Thanks!
Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Remove supressed record from total
- Thread starter kpetree
- Start date
If you can't remove the duplicate, then you need to use running totals that sum the amount, evaluate on change of field or group (if you grouped on it): invoice number, reset never for a grand total. The running total should be placed in a footer section.
-LB
-LB
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question
- Locked
- Question