Error in Crystal Reports XI Formula..

[khandu]

Hi

I am trying to put a formulain CR11 + VB6

But I am gettin a formula error in the line

if ?stat=0 then
order_details.order_id = shipping.order_id
else
order_details.order_id NOT in {shipping.order_id}

PART

NOT in {shipping.order_id}

ERROR :

The remaining part does not appear to be a part of the formula

Can anyone help ?? ive just put a logic there.. but need to actually make it work

thanks

[khandu]

OK now trying this

if {?opt} = 0 then {order_details.order_id} = {shipping.order_id} 
else NOT ({order_details.order_id} = {shipping.order_id})

The THEN part is showing result but the ELSE part is giving 0 result...

I am basically wanting all those order ID in ELSE part which DO NOT EXIST in shipping.order_id