Link to home
Start Free TrialLog in
Avatar of batang_igat
batang_igat

asked on

how to read <br> and display a new line in crystal report labels

hi guys,

i have here a crystal report label (actually its a formula field).
this formula field can display long strings.
the strings are located in a notepad.

so when the text file consists of this line:
     blah blah blah blah blah <br> blah blah
     blah blah <br> blah blah blah blah

it prints the whole string including the <br> signs.

i want the <br> to act as a new line or a carriage return and i want the crystal report label to look like this:
     blah blah blah blah blah
     blah blah blah blah
     blah blah blah blah

please help....

thanks
ASKER CERTIFIED SOLUTION
Avatar of frodoman
frodoman
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
You can actually do this without creating another formula.

Right click the field on the report, and choose Format Field.
Under the Paragraph tab, look for the drop down list at the bottom called Text Interpretation.
In the dropdown list, choose "HTML Text".
This will allow you to use certain valid HTML tags to format your text.
Avatar of batang_igat
batang_igat

ASKER

thank you both for your quick responses.

i really appreciate your help.
i used the frodoman's formula for my codes but i think bdreed35's suggestion is also correct.

thanks
Thanks for the points.  For the record, bdreed's suggestion is also correct.

frodoman