Crystal Reports 8.5 Truncates Varchar fields larger then 255 characters
Hi Lewis,
Thanks for the handy tip. I'm having the very same truncation
problem, but with CR input parameters, not display data. Are you
aware of a workaround to allow more than 255 chars in an input
parameter?
Thanks,
Michael Compton
Quote:
> I was having a lot of trouble getting my data to display correctly.
> SQL Server supports varchar fields up to 8000 characters in length.
> When returning this data to crystal reports 8.5 from a stored
> procedure, it would truncate my results to about 255 characters in
> length. The answer to my problem was simple - cast my data as a text
> field.
> example:
> Create Procedure dbo.sprReportTest
> (
> )
> As
> set nocount on
> SELECT
> FROM
> [MyTable]
> WHERE
> SELECT
> return
