Memo field display

[Former Member]

Hi,

I need to design a report where I have to display a memo field. The database is Oracle 11.2 and I connect with the MS povider ADO. When I try to print the report an error prompts saying the data type is not accepted.

I have tried to string with different formulas to less than 255 characters but the error still appears.

Crystal version is 2016 14.2

[former_member11696]

MS's Oracle driver only supports Oracle 7.

Install the Oracle Client from the Oracle install media and use it as Dell suggested

Don

[DellSC]

The MS ADO data provider for Oracle has a number of issues and I don't recommend using it. From long experience, I've found that the native Oracle connection in Crystal is MUCH more stable and efficient than any other type of connection for Oracle. If you have to use ADO, you should use the ADO data provider that comes from Oracle instead of the one from MS.

-Dell

[Former Member]

Whenever I have had this problem I have converted report to a Command and then converted memo field to Nvarchar in SQL.

Ian

[Former Member]

use

CAST( Yourmemofield AS varchar2(4000) )

Ian