Joined: 28 Feb 2014
Location: United States
Online Status: Offline
Posts: 1
Topic: Automatic Breaks Posted: 28 Feb 2014 at 7:42am
Hello,
I am a relative new user who is using Crystal reporting with my Cityworks software. I have a subreport pulling in an audit fields that keeps entered running comments. When I print the report, it will put in extra space and even carriage returns that are not there.
Joined: 21 Dec 2007
Online Status: Offline
Posts: 4372
Posted: 28 Feb 2014 at 8:08am
are you sure that they are not there? SQL Server will retain such characters, but you won't see them in a query.
you can have CR replace the values, at least I would think...
local stringvar x := {table.field};
x:=Replace(x, chrw(10),'');
x:=Replace(x, chrw(13),'');
x
maybe the extra spaces are tabs?? you could try
x:=replace(x,chrw(9),'');
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
IP Logged
