Link to home
Start Free TrialLog in
Avatar of rustypoot
rustypootFlag for United States of America

asked on

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
SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of rustypoot

ASKER

Yes on the reports the field is set to grow! Also, I already tried verify database options. No Luck!
Ok so i rebuilt the subrpt with new ORacle 11g drivers and it worked! Thanks anyways for your suggestions.
Avatar of James0628
James0628

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