I have these sample data in my report:
Car License No of Cases
133ABC 23
234EDG 15
456YUI 1
428UYT 2
897ERT 1
The number of cases are running totals based on some criteria. Now I need to count how many licenses plates that have more than 1 cases and the total number of cases. I suppressed those record with 1 case in the group, but my running totals for number of license and cases in the report footer include them.
How should I correct these problem? There is no option for me to do a condition filter based on an existing running total.
Thanks!
Deanna
Edited by: Deanna Wang on Feb 27, 2009 8:55 PM