Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Suppress an empty memo field

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
replied

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

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question