If you want it to actually exclude the data create a Summary Field as a COUNT of the table.service_call_charge_id field grouped at the Service_call field level. (Do not use a Running Total but the Summary function).
This will have been placed on the group footer.
click on it to activate it. Now click on the Select Expert and make this field >1.
There are 2 parts in the select expert.
When you open it and you click on the Show Formula you will see a toggle option for Record Selection and Group Selection.
The seelction formula you just created should now appear under Group Selection as something like...
COUNT({table.service_call_charge_id},{table.service_call})>1
Edited by DBlank - 17 Jun 2009 at 10:07am
IP Logged
