Clever Geek Handbook

Suppress text object if field value is zero in crystal

I am trying to suppress a text value in crystal by right clicking on the text object, selecting suppression and clicking x2, adding the isnull (field) formula

When I look at the preview, the text stays there when the field value is null.

+3


source to share


2 answers


In the formula section, I changed the code from

isnull(field)


to

if {field} = "" then 
 true;
+6


source


In Crystal Reports, the placeholder will still be displayed on the screen when you hover over a suppressed field. Since the field is NULL, there really won't be any visual difference between NULL and suppressed fields.



~ Nathan

0


source






More articles:


All Articles