null value in Crystal 9.2 1

[lana123]

Hi,people
My report has to show only the records where field1(string data type)is '' or null(Oracle 9)
I wrote the formula:
field1 = '' or isnull(field1)= true
But this selection doesn't show up in my where close and I cannot get the records I need
I'll appreciate any suggestions

Thanks,

Lana

 

[synapsevampire]

Crystal is odd this way, try the following:

isnull(field1)
or
field1 = ''

The null check goes first, and the = True is redundant.

-k

 

[lana123]

Thanks a lot!
It works.

Lana