Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Help needed with formula 2

Status
Not open for further replies.

JBourne77

IS-IT--Management
Jan 21, 2008
153
US
I need help with the following formula. If my field is NULL, I want it to print the word "NULL" else my field value.

IF ISNULL({Data.FSAllowed}) THEN 'NULL' ELSE {Data.FSAllowed}

This is not right obviously, because I am getting an error indicating a String is reqd. Not quite sure how to fix it.
 
IF ISNULL({Data.FSAllowed}) THEN 'NULL' ELSE totext({Data.FSAllowed})

_____________________________________
Crystal Reports XI Developer Version
Intersystems Cache 5.X ODBC connection

 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top