Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Memo Field Data

Status
Not open for further replies.

VensCH

Programmer
Mar 30, 2005
19
0
0
US
Hi All,

IF you can please help in this,

Crystal Report 10.0.0.568
Oarcle 9i
Connection :ODBC (System DSN)

We have Memo field,I just wanted display as it is.I can see
in SQL Plus editor 'Automatic generated 899.999 for Inv99..." somthing like this,

In Crystal i can see only 'Au'

Please let em know if you have any solutions,

Thanks,
Venu



 
Make sure that you make the field large enough, and format it to CAN GROW by right clicking it and selecting format field.

Also make sure that you use the proper Oracle connectivity, if using ODBC, use the Crystal supplied ODBC rather than the Oracle supplied ODBC driver.

You'll find faster results using the native connectivity though.

-k
 
Thanks a lot synapsevampire,

Can grow - yes i did this

Trying to use the oracle Native connection,let you know the out come,

Thanks,
Venu
 
Thanks once agin synapsevampire,

I got it with native connectivity,

Thanks all,
Venu
 
Using a Crystal ODBC driver is better than using the Oracle ODBC driver, however it is less desirable than native connectivity, you should use the Native connectivy for Oracle whenever possible.

-k
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top