Equal To or Not Equal To

[erinallen]

I have a report where one user wants to select parameter values to filter on and another user that wants to select parameter values to NOT filter on (do not show in report.)

Is there a way that I can do this in one parameter? This report gets ran in Crystal Enterprise.

Thanks.

 

[bdreed35]

You can accomplish this in 2 parameters; 1 to determine the IN or NOT IN and the second to allow for the range of values.

Parameter 1 should just be the values "IN" or "NOT IN".

Parameter to can be your range of values that you may have set up already.

In your Record selection criteria, you can up something like this:

switch
(
{?PARM1} = "IN", {Customer.Customer ID} IN {?PARM2},
{?PARM1} = "NOT IN", NOT({Customer.Customer ID} IN {?PARM2})


~Brian