|
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.
Any idea why this is happening?
|
|
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),'');
HTH
|
IP Logged
