Skip to Content
avatar image
Former Member

how to make string bold and text size in formula editor

hi.

in formula editor i written like below..

(If {Command.u_i8_addline1} = '' then '' else {Command.u_i8_addline1})&

(If {Command.u_i8_addline2} = '' then '' else {Command.u_i8_addline2})&

(If {Command.u_i8_addline3} = '' then '' else {Command.u_i8_addline3})&

(If {Command.u_i8_addline4} = '' then '' else {Command.u_i8_addline4})&

(If {Command.U_I8_Cityname} = '' then '' else {Command.U_I8_Cityname})&

(If {Command.U_I8_Statename} = '' then '' else {Command.U_I8_Statename})&

(If {Command.U_I8_Zipcode} = '' then '' else {Command.U_I8_Zipcode}&chrW(13))&

(If {Command.U_I8_Data3} = '' then '' else{Command.U_I8_Data3}&chrW(13))&

(If {Command.U_I8_Data4} = '' then '' else {Command.U_I8_Data4}&chrW(13))&

uppercase("CIN:" &If {Command.U_I8_CinNumber} = '' then '' else {Command.U_I8_CinNumber})

what i need is in last line

uppercase("CIN:" &If {Command.U_I8_CinNumber} = '' then '' else {Command.U_I8_CinNumber})

i need to make bold colour and size should be little bit bigger than previous lines..

i don't want to make it separate formula for last line..

bcz previous lines,  how much of data it is having i don't know

Can make it bold and size increase..........

Add comment
10|10000 characters needed characters exceeded

  • Get RSS Feed

2 Answers

  • Best Answer
    Dec 24, 2014 at 07:14 AM

    Hi Srini,

    Try this please:

    '<h1><b>' & uppercase("CIN:" &If {Command.U_I8_CinNumber} = '' then '' else {Command.U_I8_CinNumber}) & '</b></h1>'

    RIght-click the formula field > Format field > Paragraph tab > Under 'Text Interpretation' choose 'HTML Text'.

    -Abhilash

    Add comment
    10|10000 characters needed characters exceeded

  • Dec 24, 2014 at 07:18 AM

    Hi,

    This can be set with html tags.

    Try with below steps:

    1. Right click on the formula after inserting it into where you want to display in your report.

    2. Select "Format Field" and navigate to Paragraph tab and under Text interpretation, select HTML Text.

    3. Now, in your formula content, modify the last line i.e. "uppercase("CIN:" &If {Command.U_I8_CinNumber} = '' then '' else {Command.U_I8_CinNumber})" as below:

    "<h2>" & uppercase("CIN:" &If {Command.U_I8_CinNumber} = '' then '' else {Command.U_I8_CinNumber}) & "</h2>"

    This will set the font size as 1.5 times the normal font size set and bold.

    Though there is a tag for bold, I am not sure whether there is something for font size.

    Hope this suffices your requirement.

    Thanks,

    Raghavendra

    Add comment
    10|10000 characters needed characters exceeded