SQL Server 16 char Text field truncating.

[LAD]

Is there any way to display more than 254 characters for a memo field in Crystal Reports? I am working with a Microsoft SQL server and the datatype for the field is 16 char Text field. I a have changed the format so that the field can grow in Crystal but the information is still being truncated. I working with Crystal Reports Version 8.5

 

[kenhamady]

Out of the 16 characters that are available, how many is it printing?

Have you tried verifying the database to make sure CR has an up-to-date snapshot of the data? Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.

 

[LAD]

I misrepresented the data type. In MS SQL the data type is refered to as text with a length of 16. The defintions of the data type is as follows

TEXT
Variable-length non-Unicode data in the code page of the server and with a maximum length of 231-1 (2,147,483,647) characters. When the server code page uses double-byte characters, the storage is still 2,147,483,647 bytes. Depending on the character string, the storage size may be less than 2,147,483,647 bytes.

In the Crystal Report only 891 characters of the 2596 chacters that are in that record are being displayed.

I can get MS Access to display all 2596 characters. Is there any way that Crystal will display all of the Characters?

 

[balves]

We ran into this on a recent customer project. Since we were using ADO and stored procs, we converted the TEXT field to varchar() before sending it to Crystal. In SQL Server 7 and beyond, varchar() can hold 8000 characters (only 255 in V6.5 and before). Brian J. Alves
Email: brian.alves@worldnet.att.net
VB / Crystal / SQLServer