Search code examples
crystal-reports

suppress text object if field value is null in crystal


I am trying to suppress the text value in crystal by right clicking on the text object, selecting suppress and hitting the x2 button and adding the formula

isnull(field) 

When I look at the print preview the text is still there when the field value is null.


Solution

  • In the formula section, I changed the code from

    isnull(field)    
    

    to

    if {field} = "" then 
     true;