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?
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?