• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 415
  • Last Modified:

Crystal REports truncating Oracle field

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
0
rustypoot
Asked:
rustypoot
  • 2
  • 2
2 Solutions
 
mlmccCommented:
Is the field on the report wide enough for 80 characters?

DO you have it set to grow?

mlmcc
0
 
James0628Commented:
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.

 James
0
 
rustypootAuthor Commented:
Yes on the reports the field is set to grow! Also, I already tried verify database options. No Luck!
0
 
rustypootAuthor Commented:
Ok so i rebuilt the subrpt with new ORacle 11g drivers and it worked! Thanks anyways for your suggestions.
0
 
James0628Commented:
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.

 James
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now