suppress text object if field value is null in crystal

Question

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.

Archilochus

Do you mean right-clicking on the text object, selecting Format Text..., checking the box beside Suppress, then hitting the x-2 button? – Articulate

@Articulate this is what I see as well. – Community

Answer 1

In the formula section, I changed the code from

isnull(field)    

to

if {field} = "" then 
 true;

Archilochus

I've looked for this simple answer for awhile. THANK YOU! – Zobias

Answer 2

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

Morey

Answer 3

I can put my field in a section, right-click on the section (left margin of the editor) and select Section Expert... In the Section Expert, I ensure the correct section is selected, then I can check the box for "Suppress Blank Section".

Articulate

Answer 4

Really all you needed was a pair of {} inside ().

Correct line of code to suppress anything in report if it's null is:

isnull({your_report_name.database_field_name})

Strawworm

Answer 5

I suggest:

if ((trim({db.field}) = "") OR (IsNull({db.field}))) then
 >>>
else...

Cosgrove

/help/formatting – Danit