Technical Questions
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Technical Questions
Message Icon Topic: Strange text wrapping issue Post Reply Post New Topic
Author Message
bspencer1
Newbie
Newbie


Joined: 26 Nov 2013
Online Status: Offline
Posts: 26
Quote bspencer1 Replybullet Topic: Strange text wrapping issue
    Posted: 10 Feb 2014 at 10:05am
Hello, everyone.  I am experiencing a strange text wrapping issue.  The field in the DB is what you see in the blue box in the image below, but the text renders on the report like you see in red box.  I have other text fields that are longer than this one, and they do not wrap like this on the report (like the comment just above this one).  I have seen this issue before in years past with some other applications whereby a hidden symbol was in the text, but I cannot find anything like that this time.  But I do not know what else it could be.  The field is nvarchar (1000) from the DB.  Any ideas?


Edited by bspencer1 - 10 Feb 2014 at 10:06am
IP IP Logged
DBlank
Moderator
Moderator


Joined: 19 Dec 2008
Online Status: Offline
Posts: 9053
Quote DBlank Replybullet Posted: 10 Feb 2014 at 10:36am
carriage returns?
try and use a replace on your field to remove them
 
replace({table.TS_INTERNAL_COMMENT},CHR(13),'')
IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Quote lockwelle Replybullet Posted: 11 Feb 2014 at 5:04am
just as another way of looking at the data...select in a query on the database, then copy the value and paste it into a text editor and see if it behaves the same way.
IP IP Logged
bspencer1
Newbie
Newbie


Joined: 26 Nov 2013
Online Status: Offline
Posts: 26
Quote bspencer1 Replybullet Posted: 11 Feb 2014 at 8:06am
Thanks for your reponses.  From the DB, there are no carriage returns.  By happenstance, I opened an old version of the report and I noticed it was not wrapping.  When I looked at the difference between the two reports, the text field was set to text interpreation HTML on the report where it did not wrap, and it was set to "none" on the one where it did wrap.  Once i changed it to HTML, it no longer wraps.  So, I thought it was probably something in the formula that was being interpreted, but I do not see anything odd:
 
"Timesheet Comments: " + {AXProjectPostedTransaction_query.TS Internal Comment}
 
go figure...
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.