Text in field being truncated 1

[JCAbsolute]

Hi
Using Crystal v10 I am reporting from a simple csv file. One of the fields in the csv file contains significant amounts of text. When displayed on my crystal report, this text is truncated despite having the Can Grow option set to 0. Playing around with fonts, size, location etc... has no effect. Same result if source of data is an Excel file rather than csv. I have had it showing fully on another report but can't see what is different.
Help gratefully received.
Thanks in advance.

 

[dgillz]

Is this "significant amount" more than 255 characters?

Also, can grow needs to be checked, not just set to zero. Is the checkbox checked?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[JCAbsolute]

Hi
Yes there is more than 255 characters in the field. And I do also have the Can Grow option ticked. When attempting to get all the text to show from an Excel file source, I have tried with the fields formatted as General and also Text.
Thanks.
Janice

 

[dgillz]

I believe this is a limitation of Excel but I have no way of knowing this or testing it (I don't have crystal 10). Maybe one of the other gurus onhere will weigh in?

Software Sales, Training, Implementation and Support for Macola, eSynergy, and Crystal Reports

http://www.gainfocus.biz

"If you have a big enough dictionary, just about everything is a word"
--Dave Barry

 

[ejanakieff]

I have had the same problem with Crystal Reports 8.5.
The problem was the connection type.

I have made a SQL Server connection.

I have made a "Microsoft SQL Server" connection and the text fields are truncated to 255 chars.

I have change to a "OLEDB" connection, and the text field aren't truncated.

Eva Janakieff