cancel
Showing results for 
Search instead for 
Did you mean: 

Memo field display

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (3)

Answers (3)

0 Kudos

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
Active Contributor
0 Kudos

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
0 Kudos

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
0 Kudos

use

CAST( Yourmemofield AS varchar2(4000) )

Ian