Formula to check if string is empty in Crystal Reports

Question

I have written a formula to return a string based on logic run on a string field in my database   I have everything working  except I m unable to return when the field is the empty string   This is what I need       else if   TABLE FIELD        then      Fixed        However  this entry appears as the empty string in my report   I ve tried testing the length of the field to 0 and the StrCmp functions   Nothing seems to work   Google results state that a simple comparison to    or    should make the logic work   I am new to CR  so maybe I am missing something   Any ideas on how I can acquire this functionality

User · Answer

On the formula menu just Select  Default Values for Nulls  then just add all the fields like the below     Table Field1      Table Field2      Table Field3      Table Field4      Table Field5

User · Answer

If IsNull  TABLE FIELD1   then     NULL          TABLE FIELD2  else    TABLE FIELD1            TABLE FIELD2   Here I put NULL as string to display the string value NULL in place of the null value in the data field  Hope you understand

User · Answer

You can check for IsNull condition   If IsNull  TABLE FIELD   or  TABLE FIELD       then      do something

User · Answer

if  le gur bond gur1     or IsNull  le gur bond gur1     Then        else    and      le gur bond gur2      of     le gur bond grr 2 address2

[crystal-reports] Formula to check if string is empty in Crystal Reports

Examples related to crystal-reports