Reformat memo field as string

[Former Member]

I am trying to use some user-defined fields in SAP Business One in a Crystal Report. The alphanumeric fields are being show in CR as memo fields rather than string. I need to do select (filter) and group based on these fields. How do I convert them to string?

[ido_millet · Accepted solution]

You could use LEFT(, 100) or similar logic.

[Former Member]

Hi David

Try using cstr(<field name>)

Hope this helps.

Regards

Nik