how to make string bold and text size in formula editor

[Former Member]

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

[abhilash_kumar · Accepted solution]

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

[raghavendra_hullur]

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

[raghavendra_hullur]

Ah, I just now saw that Abhilash has already replied to this .

You can use whichever suits your requirement.

Thanks,

Raghavendra

[Former Member]

i will check it...