Crystal XI "NOT LIKE" function/formula

[pungigis]

select *
from accumulator
where accumtype = 'Maxout' and
(description not like '%OON%' and
description not like '%In-Net%')

I need to incorporate the above SQL criteria into a Crystal XI report formula but it is NOT working, any ideas?? Below is my Crystal formula.

if {accumulator.accumtype} = 'Maxout' and
(not("*OON*" in {accumulator.description}) and
not("*In-Net*"in {accumulator.description}))
then {claimdetail.coinsuranceamt}

 

[Turkbear]

Hi,
CR also uses LIKE as an operator so try:

if {accumulator.accumtype} = 'Maxout' and
(
not({accumulator.description} like "*OON*" )
 and 
not({accumulator.description} like "*In-Net*" ) 
)
then {claimdetail.coinsuranceamt}

If any NULLs are possible, test for them first.








To Paraphrase:"The Help you get is proportional to the Help you give.."