Solved

Crystal reports 2013 only showing first letter of memo field

Posted on 2014-10-21
1
646 Views
Last Modified: 2014-10-21
We have recently upgraded to Windows 7 and Crystal Reports 2013. And now I have a simple report that has a memo field that Crystal is only pulling through the first character. I have checked the field and ticked 'can grow etc'.

If I go back to Crystal 2008 in Windows XP, the full data of the field is pulled through.
If I use Crystal 2008 on Windows 7, only the first character is pulled through.

To me it looks like something to do with Windows 7. On XP we use the Microsoft ODBC connection to our Oracle database, on Windows 7, we use the Oracle 11g client ODBC connection. (As Microsoft ODBC is no longer available with Windows7)

What do the experts know? Is there something within Crystal 2013 that we need to do differently to use the memo field. Or is there an MDAC for Windows 7 we can install (and if so where/how)

Or, can we convert the memo field within Crystal to another type to then get it to display. However I guess if Crystal isn't getting the data through the connection in the first place, then a conversion is not going to work.
0
Comment
Question by:nicbak13
1 Comment
 

Accepted Solution

by:
nicbak13 earned 0 total points
ID: 40395911
Found answer ------> Crystal 2013 requires you to use its internal drivers for Oracle. Once you update (Set Database location) using the internal drivers, the problem is fixed.

Clever me I guess
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

I hate sub reports and always consider them the last resort in any reporting solution.  The negative effect on performance and maintainability is just not worth the easy ride they give the report writer.  Nine times out of ten reporting requirements…
Hello everyone, Hope you find this as helpful as we did. We have on the company I work for an application built in Delphi V with Crystal Reports 8. We all know that Crystal & Delphi can be temperamental sometimes and the worst thing is, nearly…
This demo shows you how to set up the containerized NetScaler CPX with NetScaler Management and Analytics System in a non-routable Mesos/Marathon environment for use with Micro-Services applications.
This video demonstrates how to create an example email signature rule for a department in a company using CodeTwo Exchange Rules. The signature will be inserted beneath users' latest emails in conversations and will be displayed in users' Sent Items…

929 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

10 Experts available now in Live!

Get 1:1 Help Now