Crystal Select expert issue

Question

I am having trouble setting this scenario in Select Expert - Report:

Pull all records from the tables if

There is no ID associated with this form number

OR

There is a ID associated with this form number but the ID_STATUS is not one of 1,2,3

OR

There is a ID associated with this form number but the ID_STATUS is null

My Tryout:

( isnull ({EMPLOYEE.ID}) or  
  ( Not isnull ({EMPLOYEE.ID}) and  
    ( not ({EMPLOYEE.ID_STATUS} in [3.00, 2.00, 1.00]) or  
      isnull ( ({EMPLOYEE.ID_STATUS}) )  
    )  
  )

Thanks,

Answer 1

There are a few small problems with your code, but what's preventing it from working (probably) is that you're not treating not() as a function on the fifth line. Try this.

isnull({EMPLOYEE.ID})
or isnull({EMPLOYEE.ID_STATUS})
or not({EMPLOYEE.ID_STATUS} in [1,2,3])

There's no need to check if not(isnull({EMPLOYEE.ID})) since there are only two possibilities: either the ID status is null or it isn't.