How To Use <br> in Crystal Report

[former_member1229785]

Hi All

   i have try this formula how to use <br > with this formula

If Right({DataTable1.col1},2) = 'J3' then

    Replace({DataTable1.col1},'J3','<b>J3</b>')

else {DataTable1.col1};

[abhilash_kumar]

Hi Prasanna,

Try:

If Right({DataTable1.col1},2) = 'J3' then

    Replace({DataTable1.col1},'J3','<b> <br>J3</br></b>')

else {DataTable1.col1};

-Abhilash

[former_member1229785]

using ur formula with <br > it's not working...

[abhilash_kumar]

I can see that the formula works. You would need one more break to align it with the others:

If Right({DataTable1.col1},2) = 'J3' then

    Replace({DataTable1.col1},'J3','<b><br> <br>J3</br></br></b>')

else {DataTable1.col1};

-Abhilash

[former_member1229785]

i just try with this

If Right({DataTable1.col1},2) = 'J3' then

    Replace({DataTable1.col1},'J3','<b><br> <br><br> <br>J3</br></br></br></br></b>')

else {DataTable1.col1};

it's not working just same output, is there another way or what to do.?

[abhilash_kumar]

Try:

If Right({DataTable1.col1},2) = 'J3' then

    Replace({DataTable1.col1},'J3','<b><br> <br>J3</b>')

else {DataTable1.col1};

-Abhilash

[former_member1229785]

i have anything wrong....

[abhilash_kumar]

Looks fine to me but you don't need those many <br> tags. I guess just two should be fine.

-Abhilash

[former_member1229785]

But Abhilash even though it's not working , that's y i gave it is there another way... to do this...

[abhilash_kumar]

I'm not too sure why it doesn't work for you while it works for me!

Here's another version:

If Right({DataTable1.col1},2) = 'J3' then

   Replace({DataTable1.col1},'J3','')&'<b><br><br>'&'J3'&'</b>'

else {DataTable1.col1};

-Abhilash

[former_member1229785]

Not Working for me...