Link to home
Start Free TrialLog in
Avatar of Amy Loyd
Amy Loyd

asked on

Crystal Reports line feed/carriage return causes indent of subsequent line

I have a formula that concatenates two text fields and puts a linefeed/carriage return wherever there is a semicolon.
The new line, after the line feed/carriage return, is indented one space. I want the text all aligned to the left with no indents. I checked the field format paragraph alignment and all indentation settings are 0.

Here’s the formula:
Replace({Command.T3_2215}+ ' '+ {Command.AISDCURRENTPROJSTATUS1},";",";"+Chrw(10))

Using Chrw(13) does the same thing.

Here’s the output:

Metal framing nears completion;
 Roof work is 40% complete;
 MEP rough-in is nearing completion;
 Driveway curbs and gutters are scheduled to pour 7/31/2015;
 Retaining wall at the pond excavation is
underway;
 Brick is onsite and mock up panel has
been approved.
SOLUTION
Avatar of Mike McCracken
Mike McCracken

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
ASKER CERTIFIED SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
SOLUTION
Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
Avatar of Amy Loyd
Amy Loyd

ASKER

Thank you all so much. I tried both ChrW(10) and Chr (10) with the same results. I mentioned ChrW in my post because it was listed as the most current function. I put a space after the semicolon IdoMillet suggested and it worked perfectly.