Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Replicate String makes the value off in CMC

Status
Not open for further replies.

crystal28

Programmer
Oct 23, 2002
108
US
I used this in a formula

replicatestring(" ",146)& trim({Command.S2ADD1})
else if isnull({Command.S2ADD1}) then
replicatestring(" ",146)& trim({Command.S2ADD2})
else if (not(isnull({Command.S2ADD1}) and not isnull({Command.S2ADD2}))) then
replicatestring(" ",146)& trim({Command.S2ADD1}) & " , " & trim({Command.S2ADD2}))

This formula evaluates a string that has 3 lines
Name
Address
City etc

This is later concatanated with 3 other strings and all form a formula that is in teh Group Header,when i publish this in CMC its all off,it looks perfect in Crystal,but when published in CMC the formula that pads the string using Replicate string is having the values messed up,that is bad alignment,i know if i have it in a different field it will work just fine,is there a way to not have a different field and still make this look good?
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top