I've a report based off a stored procedure in Oracle 10g. The query works fine and there is a field of service type with datatype as varchar with 80 bytes. I've Business View in between Crystal reports & database. When i run the report from Crystal, the original value of the "Service Type" field gets cut off. For eg., it has "Product Line" value for "Service Type" field in database but when i run the report i get only "Product Li". Also, i noticed the datatype in Crystal is string with length as 10. When i browse the data from crystal i can not see the full value of the fields. It's cutting off there too. Please help.