Data field is more than 255 characters

[B1naryPro]

I have a datafield in my cyrstal reports that is linked to a sql server database. My problem is when this datafield is over the 255 characters, it cuts off. I was wondering if anyone had a good document or solution to this problem and if it involves subreports, it would be great to have instructions. thanks JPBinary
MCSE, MCSA

 

[IdoMillet]

Move the CR 9.0 or bring in the field as several columns using SQL Server functions to "select" these pieces.

Then, combine the pieces again by dropping the columns into a single text object.

Cheers,
- Ido CUT, Visual CUT, and DataLink Viewer:
view, e-mail, export, burst, distribute, and schedule Crystal Reports.

http://www.MilletSoftware.com

 

[synapsevampire]

I don't get these fields cutting off, you're the second person I've heard of this happening to, what is the datatype in SQL Server, and what verions of CR and SQL Server? I've tried both Varchars and Ntext and the field displays in it's entirety using CR 8.5.

CR should recognize it as a Memo type field for chars, varchars or ntext, and will display it in it's entirety, you just can't use it in formulas prior to version 9.

Anyway, try creating a SQL Expression from it and use Cast it to make it another type, such as Ntext, varchar or char:

cast(textfld as ntext)

-k

 

[synapsevampire]

It just dawned on me that this might be connectivity related, try switching the type, if you';re using ODBC, try OLE DB, etc.

-k