How to Customize font in crystal report

[Former Member]

Hi Experts ,

I have a formula field like this  {HBL.SEGMENT_CODE}+' - '+cstr({HBL.JOB_NO})+' - '+cstr({HBL.SUBJOB_NO}).

I need {HBL.JOB_NO} alone  in BOLD font and Blue Color , How to do this .

[Former Member · Accepted solution]

Hi sriram,

         Use the text box.drag your {HBL.SEGMENT_CODE} field and type - after that drag other fields into the text box.Select {HBL.JOB_NO} in that new text box and right click.Now you change font size,type and color

[abhilash_kumar]

Hi Sriram,

Here's what you need to do:

Modify the formula and use this code:

HBL.SEGMENT_CODE}+' - '+"<b><font color = 'blue'>" &cstr({HBL.JOB_NO})& "</b></font>" +' - '+cstr({HBL.SUBJOB_NO})

Then, right-click this formula field > Select Format Field > Paragraph tab > choose 'HTML Text' as the 'Text Interpretation'.

Hope this helps!

- Abhilash

Follow us on Twitter

Got Enhancement ideas? Try the SAP Idea Place

Share Your Knowledge in SCN Topic Spaces