asked on

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.

Thanks

ASKER CERTIFIED SOLUTION

frodoman

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

frodoman

Sorry for the typo, should actually be:

================================
stringVar MyResult := '';

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;

================================

FTIISD

ASKER

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.

Thanks.

frodoman

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.

Mike McCracken

The formula idea will work for CR9 and 10. For earlier versions so long as the text doesn't exceed 255 characters it will work.

The inserting into a text box is the method for getting around the ength limitation.

I agree with frodoman, if single vs double space is important use the formula.

mlmcc