MySQL Forums
Forum List  »  General

memo field truncating when trying to display field with crystal reports 10
Posted by: Grace Chan
Date: March 01, 2005 10:20AM

I am using crystal reports 10 connecting to a mysql 4.0.18. The report we are trying to produce needs to display a memo field. However, we are having two problems.

The first problem is that the memo field truncates when there is too much text. I have not figured how many letters it starts to truncate at because it differs. It doesn't always cut off after displaying 255 characters. It will cut of sooner if there is carriage return in the line.

The second problem we have is that it randomly cuts off after special characters, especially after the ampersand ("&").
An example is the following:
In our database:
so & so so & so so & so so & so so & so so & so
only "so & so so & so so & s" shows up in crystal reports.

If we have so & so
only "so" shows up when text interpretation is set to none or html text.

I tried to connect to a MSSQL database and it displays fine. Not exactly sure why MySql wouldn't work.

Is there something that I ahve to configure in the mysql drivers?

Any help is appreciated. Thank you.

Options: ReplyQuote


Subject
Written By
Posted
memo field truncating when trying to display field with crystal reports 10
March 01, 2005 10:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.