Memo field printing a "Z" with an upside down "^" on top of

[JFawcett]

My Memo fields print a "Z" with an upside down "^" on top of it instead of doing a carriage return. I am printing from an AS400 database. The Hex value of the carriage return looks like this:

invoices. ¬ **All
489A9888A440455C994
095569352B0A0CC1330

The carriage return is between the period and the asterisk.

The prints looks like this:
invoices. Ž **All

I need it to look like this:
invoices.
** All

 

[synapsevampire]

A quick cheat is to create a formula contining:

mid({table.memo},2)

Now display this formula instead of your memo field.

Of course this is dependent upon your software version which you didn't post.

You might also remove the offending character in a SQL Expression.

Again, this is version dependent, supplying technical information is more important than descriptions.

-k

 

[JFawcett]

Sorry about that. I'm using Crystal Reports Professional version 8.5 and it will not allow you to use a memo field in a formula.
Is there a way in SQL to replace that HEX value with an actual carriage return?