crystal report section expert Suppress Checkbox and formula?

I have a formula to suppress the section,  
When the suppress checkbox is checked, the report returned less rows than it's uncheked?

Could someone please tell me what the difference is?
thanks
HemlockPrintersAsked:
Who is Participating?
 
mlmccConnect With a Mentor Commented:
What version of Crystal?

Can the database fields in the suppression be NULL?

The recommended practice with the checkboxes is to use the checkbox to ALWAYS in this case suppress.  If you want to conditionally suppress then leave the box unchecked and add the formula.

I have noticed a difference in how it works with a formula between when the box is checked or unchecked.  At first I thought the suppression formula was maybe working in reverse but now for the first time I think it might be that a field is NULL in the test.

When Crystal evaluates a formula with a NULL field unless the test in IsNull the evaluation terminates and the result is undetermined so in that case the check box setting might take over.

mlmcc
0
 
ecarboneCommented:
What is the formula you used in the suppress condition?
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.