CODEWITHSUNDEEP
crystal-reports
Sash
Sash

Reputation: 315

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.

Upvotes: 7

Views: 40813

Answers (5)

user22110835
user22110835

Reputation: 1

I suggest:

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

Upvotes: 0

Nathan Patrick Taylor
Nathan Patrick Taylor

Reputation: 61

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.

Upvotes: 0

Kasia Wichrowska
Kasia Wichrowska

Reputation: 321

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})

Upvotes: 0

dougp
dougp

Reputation: 3089

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".

Upvotes: 0

Sash
Sash

Reputation: 315

In the formula section, I changed the code from 

isnull(field)

to

if {field} = "" then 
 true;

Upvotes: 14

Related Questions