Crystal Truncates long SQL Strings

[Tober]

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

 

[synapsevampire]

Yeah, direct later became a download only alternative, and now I think they only support ODBC for SQL Server.

-k