Suppress Text based on NOT IS NULL and Blank Field

[akabatman2]

Hi all,

I have come accross an issue with trying to suppress a text field based on the following formula:

NOT ISNULL({Command.Notes}) OR {Command.Notes}<>&quot;&quot;

I want to suppress a text field if the Notes contain either some data or a blank(i.e. a space or empty string).

The formula above doesn't work when the notes field is NULL, unless I only use the following:

NOT ISNULL({Command.Notes})

What formula do I need to account for blanks, spaces or NULLs for use in a Crystal suppression formula.

Thanks,
Tom

 

[synapsevampire]

So you want to suppress if there is data or a blank, but show it if it's null?

&quot;I want to suppress a text field if the Notes contain either some data or a blank(i.e. a space or empty string).&quot;

Unusual request:

not(ISNULL({Command.Notes}))

Will show null fields, you shouldn't need anything else.

If what you're trying to say is that you want to only show fields without data, either nulls or blanks, use:

ISNULL({Command.Notes}) or trim({Command.Notes}) = &quot;&quot;

-k

 

[akabatman2]

Yes, it's an unusual request, basically, what I am doing is, showing a text box with a bottom border as a line if there are no notes.

Basically, if there are notes show them if there aren't show lines.

Thanks, I'll try that. I appreciate the response.

Tom