If then staement to enter text value 1

[Buzzmeister14]

I havea report that I'm building in CR8.5
from a DB on SQL2000

And would like to show a fixed text value if a condition is met have tried

if {field_name} = 0 then "NOT TAKEN"

however it does not display the nto taken when value is 0

Am new to CR any help appreciated ahev tried solutions similiar from this site no joy yet

 

[dgillz]

Its probably null and not zero.

Try this formula:

If IsNull({YourField}) or {YourField}= 0 then "Not Taken"

Software Sales, Training, Implementation and Support for Exact Macola, eSynergy, and Crystal Reports
askdon@srhconsulting.com

http://www.srhconsulting.com

 

[Buzzmeister14]

That worked perfectly thanks Dgillz

overlooked the null value