Using select expert with Memo field

[nishi1982]

I want to create a report that displays records if the memo(string) field is not blank i.e. there is some information in it.
I was able to do it with non memo fields by using the select expert and filtering out not null values. However, this string is too long and is a memo field. So I can not use it with the select expert. Can You guys help me in this so that I'll only see the records where the Memo field is not null.
Thanks.

 

[lbass]

You can use a selection formula like:

not isnull({table.memo})

You might have to type in the field name manually. This should work, although I'm not sure whether the length is a factor. If it doesn't, try creating a SQL expression with syntax like one of the following {%memo}:

(substr(table."memo",1,254))

Or, like:

{fn substring(table.`memo`,1,254)}

Then in the record selection formula you can use:

not isnull({%memo})

I'm assuming you are using v. 8.x where you can only use strings up to 255 in length. You could add additional substrings to make up the rest of the memo field and place them in a text box for display.

-LB