Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: CR XI string field 255 character limit Post Reply Post New Topic
Author Message
snilloctony
Newbie
Newbie


Joined: 23 Dec 2011
Online Status: Offline
Posts: 1
Quote snilloctony Replybullet Topic: CR XI string field 255 character limit
    Posted: 23 Dec 2011 at 4:43am
I am using crystal reports pro 11.0.0.1282

the report data source is a sql view (the database is on a MSSQL server 2005), connected by an ODBC connection

I am having an issue with a notes field (the field in the sql view is a varchar(max); most of the records have more than 255 characters in this field; outside the crystal report the data can be viewed fully; however in the report it gets truncated at 255 characters)

I thought there was no longer a limitation on string limitation on string fields?
IP IP Logged
gsaunders
Newbie
Newbie


Joined: 09 Apr 2012
Online Status: Offline
Posts: 20
Quote gsaunders Replybullet Posted: 08 Aug 2012 at 3:49am
I know this is an older post, but we are having same issue with varchar(max) being truncated in reports.  Is there a way around this?
IP IP Logged
Sastry
Moderator
Moderator
Avatar

Joined: 16 Jul 2012
Online Status: Offline
Posts: 537
Quote Sastry Replybullet Posted: 08 Aug 2012 at 4:13am
Hi
 
Only work around for this is, need to find the maximum len of your field value then using Left(), Mid() functions you need to cut the string and in the report concatente all the strings.
 
Ex :
 
@String1 :
 
left({fieldvalue},254)
 
@String2 ;
 
Mid({fieldvalue},255, 509)
.
.
.
.
Finally you create one formula like :
 
@string1+String2+....
 
This will display entire field value.
 
 
 
 
Thanks,
Sastry
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.