Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2022 : Report Design
Message Icon Topic: Long string in database fields - cut on right edge Post Reply Post New Topic
Author Message
marcoh
Newbie
Newbie


Joined: 18 Aug 2010
Online Status: Offline
Posts: 3
Quote marcoh Replybullet Topic: Long string in database fields - cut on right edge
     Posted: 09 Dec 2010 at 11:01pm
Hello everybody,
I have a long text (String) in a DB column and put it in the database field with 'Can Grow' (to infty).

The problem is that no matter, what width of the field I set in CR design view, always some lines are cut on the right edge so that there miss sometimes complete letters.

I could not find any property in 'Format field' which can help me to set some 'internal border'/margin.

Have you ever rendered in CR long (hence multiline in report) Strings?
Please help me.
Thank you.

IP IP Logged
lockwelle
Moderator
Moderator


Joined: 21 Dec 2007
Online Status: Offline
Posts: 4374
Quote lockwelle Replybullet Posted: 10 Dec 2010 at 11:50am
the only thing that comes to mind, if the built in function is not working as desired, is to create a formula that inserts crlf chars every X number of characters, or you could get fancier and try to parse at the complete word.
 
helpful functions would be:
Mid()
Instr()
crlf = chrw(13) + chrw(10)
 
HTH
IP IP Logged
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