isnull check stopped working

[RPOC]

i am using crystal 11, The report I aam working with was written in crystal 9. and is being used by a client base and has not had any issues until now and only on 1 client location. This report runs via an odbc connection to an intersystems cache 2008 database.

I am using the below selection criteria.
IsNull({history_client_dispense.LINK_TO_SPILL_CLIENT})

If i use this no data appears when data that fits this criteria does exist. I did check the data set an the value is showing as a null value. I tested this by converting the field to a formula. The null test comes back as true. I also did a Len formula on this field and it did not return a value. If the field had values in it the tests showed it as false for teh boolean expression and the proper lenght.
I had the structure of the table reviewed and it is correct. Is something going on with cryestal reports or is it possible some default option was turned off?

 

[lbass]

Have the user check file->report options and make sure that "convert nulls to default values" is NOT checked.

-LB

 

[RPOC]

that option is not checked. I as actually thinking of chekcing it and using a new formula that would check the size of the field.

 

[Turkbear]

Hi,
Try:

IsNull({history_client_dispense.LINK_TO_SPILL_CLIENT}) 
OR
Trim({history_client_dispense.LINK_TO_SPILL_CLIENT}) = ""

Not all blanks are NULLs










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