Suppress an empty memo field

[Former Member]

Hi all,

Using CR10 I have a report where I only want to see records where there is something in a memo field.

Now the memo field isn't available to use in the record selection formula so I've got an SQL expression called "memofld" of...

substring(table.memo_field,1,254)

Then I'm putting...

not isnull({%memofld})

into the selection formula but this makes no difference. I still get entires with blank memo fields.

What am I doing wrong here?

[Former Member · Accepted solution]

Try to use the memo field in the suppress condition of the details section. Write the condition like this

len({memo field})=0

Regards,

Raghavendra

[Former Member · Accepted solution]

Raghavendra's solution sorted it for me but thank you to all who replied!

[Former Member]

HI,

Just try like this NOT ISNULL(table.memo_field)

If the field is null and you are using formula field in record selection no effect will be there.

Regards,

Sathish

[Former Member]

Check your report option and see if the 'Convert Database NULL Values to Default' and 'Convert Database NULL Values to Default' are checked, if so uncheck them.