I'm new to Crsytal and am trying to exclude a group of duplicated records when one set of criteria is met for one record within the group. The code that current exists within the report will exclude the record that meets the parameter conditions, but the other related records that do not meet the condition still appear on the report. Please see example below.

BusinessPartner Class Action
106029100 0003 0001
106029100 0024 0003
106029847 0015 0001
106029847 0003 0001

Both of these business partners are included in the selection parameter for Business Partner. In another parameter we have specified that we do not want to see those business partners that have class of 15 and action of 1. This is the result that get now:

BusinessPartner Class Action
106029100 0003 0001
106029100 0024 0003
106029847 0003 0001

The only record that has been excluded is the one that contains a class of 15 and action of 1. The business partner 106029847 still shows up on the report because it has other classes and actions that do not meet the exclusion criteria. How do I remove all the records related to 106029847 from the report?

Here is the logic that we currently have in place within the Select Expert section:
If {?Operator} = "=" then
({BCONT.CCLASS} = {?Contact Class} and {BCONT.ACTIVITY} = {?Contact Action})and
{BUT000.CRDAT} in {?BP Created On} and
{BUT000.PARTNER} = {?Business Partner}and
{BUT000.CRUSR} LIKE {?BP Created By}

Else If {?Operator} = "<>" then
({BCONT.CCLASS} <> {?Contact Class} or {BCONT.ACTIVITY} <> {?Contact Action})and
{BUT000.CRDAT} in {?BP Created On} and
{BUT000.PARTNER} = {?Business Partner}and
{BUT000.CRUSR} LIKE {?BP Created By}

Any help would be greatly appreciated!!!!