In Crystal Reports, how do I keep a row from printing if the value is null?

null crystal-reports-xi
johnny picture johnny · Aug 12, 2013 · Viewed 17.4k times · Source

I have a null value in my report. I went to the formula workshop editor and put IsNull({myreport.field}) but the row shows on the report. It has "FALSE" or "TRUE," and it putting all the records on there.

How do I actually make it suppress or not show the records if the value is null? What do I put in IF THEN (Is that what I use?)? I don't want it on the report at all.

I am using Crystal Reports 2011 XI.

Answer

ifthenelsenull picture ifthenelsenull · Aug 13, 2013

I usually use this formula to suppress blank sections. It goes in the section expert supress formula editor.

IF ISNULL({myreport.myfield}) then TRUE   
ELSE IF {myreport.myfield} = " " then TRUE   
ELSE FALSE

Since you are in the suppression field you are telling it that supress = true if the conditions are met else they are not true and it should not be supressed. I use the empty string condition to cover issues where it's not NULL but still blank.

Related questions

How can I check for an empty/undefined/null string in JavaScript?

I saw this question, but I didn't see a JavaScript specific example. Is there a simple string.Empty available in JavaScript, or is it just a case of checking for ""?

Read More
How can I determine if a variable is 'undefined' or 'null'?

How do I determine if variable is undefined or null? My code is as follows: var EmpName = $("div#esd-names div#name").attr('class'); if(EmpName == 'undefined'){ // DO SOMETHING }; <div id="esd-names"> <div id="name"></div&…

Read More
Is there a standard function to check for null, undefined, or blank variables in JavaScript?

Is there a universal JavaScript function that checks that a variable has a value and ensures that it's not undefined or null? I've got this code, but I'm not sure if it covers all cases: function isEmpty(val){ return (val === …

Read More