AnsweredAssumed Answered

Crystal Reports - Formatting Text Color

Question asked by info_tel on Feb 4, 2013
Latest reply on Feb 5, 2013 by info_tel

I'm trying to merge two string field say Text1 and Text2 into a single field (formula field) in Crystal Reports. Now i want to display the Text1 in Blue color and Text2 in a different color.

So I set the Text Interpretation to 'HTML Text' and applied the below formula (which i got for one of the million forums available online):

stringVar sLeft =Split ({@Prj_Name_TC}, ":", 1);
stringVar sRight =Split ({@Prj_Name_TC}, ":", 2);

If {Display_Change} = 0
<font color = 'black'>{@Prj_Name_TC}</Font>
<Font color='blue'>(sLeft)</Font> & <Font color='red'>(sRight)</Font>

But I keep getting the syntax error “A number, currency amount, Boolean, date, time, date-time, or string is expected here. Can anyone help me fix the issue with the formaul or if there is a better way of achieving what I'm trying to do.