Crystal Report 6 - DB Field text TRUNCATED

[rcuro]

I am doing a Crystal Report where a database field is accessed with datatype varchar 750 length. However Crystal report will only limit the string to 255. What can i do to resolve the problem? [sig][/sig]

 

[kenhamady]

Bad news.

Crystal can't handle text objects over 250. Not even to parse or substring into smaller pieces. There are no options on the Crystal side that I know of.

Choices on the data side include splitting the field into 3 pieces or converting it into a memo. Crystal can read a memo field, but it can't do anything with it (substring or use "in" operator) other than print its contents.

If you can't change the table itself, you could create a view of the table that does the conversion. [sig]<p>Ken Hamady<br><a href=mailto:ken@kenhamady.com>ken@kenhamady.com</a><br><a href=

http://www.kenhamady.com/>Crystal

Reports Taining by Ken Hamady</a><br>[/sig]