Crystal Truncates long SQL Strings
Crystal Truncates long SQL Strings
(OP)
Re: thread784-622707
I found that when you use Crystal to connect directly to SQL Server and use a string such as an Nvarchar, it tends to trunc the string down to a 255 character length, often cutting short the content.
Over, rather then programatically parsing out the data into multiple fields or records, if you make an ODBC connection to the datasource instead, it appears the ODBC driver has the ability to pass the full contents of the field to Crystal.
Version 8.5 at least.
Tober
I found that when you use Crystal to connect directly to SQL Server and use a string such as an Nvarchar, it tends to trunc the string down to a 255 character length, often cutting short the content.
Over, rather then programatically parsing out the data into multiple fields or records, if you make an ODBC connection to the datasource instead, it appears the ODBC driver has the ability to pass the full contents of the field to Crystal.
Version 8.5 at least.
Tober
Talk To Other Members
RE: Crystal Truncates long SQL Strings
-k