suppress a memo field in the detail section

[shukuo]

Hi.

In the detail section, I want to display a memo field only when it has text, I tried to create a formula field to do filter, but I don't see this memo field in the formula editor window. what show I do ?


thanks so much.

 

[BlurredVision]

What version of Crystal Reports are you running? I believe only 9 supports memo fields within a formula

 

[shukuo]

I have 8.5

 

[synapsevampire]

Create a SQL Expression to test whether the field is null and base the suppression on that.

In SQL Server you might use:

isnull(table.field,'null')

Then base the suppression on whether this SQL Expression returned the text null.

-k

 

[shukuo]

appreciate your help.

will try it out.