Testing for NULL cells and returning values

[TravisRabe]

Hello,

I have been trying to use a formula to test cells for NULL. IF they are null I want it to return a string, if it's not NULL, I want it to return the string in the cell. However, everytime I do this, it automatically reduces the number of records to those only containing a string. All of the cells that have a NULL vlaue are immediately taken from the report. Here is the code I am using.

if {Schools.SchoolName} = ' ' then
'TRUE'
else
'FALSE'

And what if I don't want it to return boolean, but strings?

 

[TravisRabe]

I have also tried this and it does the same thing.

if isNULL({Schools.SchoolName}) then
"CRAP HERE"
else
{Schools.SchoolName}

 

[synapsevampire]

One option that should help is to select convert null values to default in Options.

I typically test for both null or trim({MyTable.MyField}) = "", which seems to resolve.

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com

 

[TravisRabe]

I treid what you suggested and it still takes all 431 record and immediately reduces it to 106 becuase the remaining have null values. IT will only return the fields where there is no nul value even though I am trying to test for it.

 

[TravisRabe]

I figured it out - thanks. It was a matter of putting the check mark in the change NULL to default values - THANKS.