Crystal reports trimming spaces at the end of fields.
Hi,
I am placing multiple fields into a text box. These each of these fields in the database contain a space at the end. For some reason crystal reports is removing these spaces. I need it to place a space between each of the fields. I attempted to put a space in the text box between the fields, but if the field is blank it will leave two spaces.
If trim({table.field1}) <> '' Then
MyResult := {table.field1};
If trim({table.field2}) <> '' Then
MyResult := MyResult+' '+{table.field2};
If trim({table.field3}) <> '' Then
MyResult := MyResult+' '+{table.field3};
...etc...
MyResult;
================================
0
FTIISDAuthor Commented:
Is there any other way to do this? Is there a reason that crystal reports is removing these spaces? I have an extremely long reports, and this method will take a long time.
I have no idea "why" but it's not even consistent between versions.
How long your report is doesn't matter as much as how many fields you're combining into a single text box. I don't know of an easier way to do this. Honestly I usually just put the space between the fields and ignore the extra spaces when they happen - I use a variable width font so you have to really look closely to see the difference between one space and two anyway.
I would consider instead creating a formula so you can control the results. Something along these lines:
==========================
stringVar MyResult := '';
If trim({table.field1}) <> '' Then
MyResult := {table.field1};
If trim({table.field2}) <> '' Then
MyResult := ' '+{table.field2};
If trim({table.field3}) <> '' Then
MyResult := ' '+{table.field3};
...etc...
MyResult;
==========================