Crystal REports truncating Oracle field

Posted on 2012-09-17
Last Modified: 2012-09-18
I am using Crystal Xi and ORacle 11g for this report.

The datatype in Oracle is defined as Varchar2(80) for 2 of the fields.

Crystal REports is only displaying first 40 characeters from these fields.

Any ideas on resolution? Thanks
Question by:rustypoot
    LVL 100

    Assisted Solution

    Is the field on the report wide enough for 80 characters?

    DO you have it set to grow?

    LVL 34

    Accepted Solution

    Do you mean that when you put the field on the report, you don't see all of the characters?

     If so, then the obvious thing, as mlmcc suggested, is to try making the field bigger or setting "Can Grow".

     Or do you mean that when you look at the list of fields in the Field Explorer, CR is actually saying that the fields are 40 character string fields, instead of 80?

     If that's what you meant, you could try going to Database > "Verify Database" and see if that helps.  If the fields were expanded recently, maybe CR hasn't noticed the change yet, in which case "Verify Database" should help.  Apart from that, I don't know what to suggest, since I've never used Oracle.


    Author Comment

    Yes on the reports the field is set to grow! Also, I already tried verify database options. No Luck!

    Author Comment

    Ok so i rebuilt the subrpt with new ORacle 11g drivers and it worked! Thanks anyways for your suggestions.
    LVL 34

    Expert Comment

    Glad you were able to find a solution. FWIW, I think you could have just accepted your own post as the solution, since it doesn't appear that my post or mlmcc's really helped.


    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    Find Ransomware Secrets With All-Source Analysis

    Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

    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…
    how to add IIS SMTP to handle application/Scanner relays into office 365.
    Illustrator's Shape Builder tool will let you combine shapes visually and interactively. This video shows the Mac version, but the tool works the same way in Windows. To follow along with this video, you can draw your own shapes or download the file…

    737 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

    22 Experts available now in Live!

    Get 1:1 Help Now