Any value in a field in a formula 1

[CRock2442]

basically what i want is, if there is any value in a certain field, that it will print "cut" on the report
i tried: if {thefieldinmydatabse} = "*" then "cut"
apparently the asterik doesn't work. what can i use, or how can i properly write this formula?
thanks in advance!

 

[lbass]

Try:

if not isnull({table.field}) or
len(trim({table.field})) <> 0 then "cut"

-LB

 

[CRock2442]

we're almost there, however now it is printing "cut" for every job. i only want "cut" if there is a value in that field, because half the time there isn't a value at all.

 

[lbass]

Please go to file->report options and uncheck "convert nulls to default value".

-LB

 

[CRock2442]

it was unchecked
any other ideas?
thanks a lot for your assistance on this!

 

[lbass]

Are you seeing detail rows where the field appears to be blank or null and the formula is still saying "cut"? What is the datatype of the field? If it is a number, have you verified that it is not formatted to "suppress if zero"?

-LB