I have Crystal Reports 10 (CR Developer; FULL ver 10.0.5.1177) I'm using to hit the a field in an oracle database {LONGDESCRIPTION.LDTEXT}.
I'm currently using a formula to convert rtf to html and I'm also using the format "text interpretation set to html".
Formula works great-
However my output goes from this-
SAFETY INFORMATION:<br /><br />OBSERVE ALL SAFETY STANDARDS AND PRECAUTIONS<br />VERIFY SIGN
To this-
SAFETY INFORMATION:<br><br>OBSERVE ALL SAFETY STANDARDS AND PRECAUTIONS<br>VERIFY SIGN
Which is good because when I format it to html, it views like this-
SAFETY INFORMATION:
OBSERVE ALL SAFETY STANDARDS AND PRECAUTIONS
VERIFY SIGN
However, after the word "INFORMATION" notice that there are 2 break tags. The data should appear like this-
SAFETY INFORMATION:
OBSERVE ALL SAFETY STANDARDS AND PRECAUTIONS
VERIFY SIGN
So now to my question, is there any way to display the 2 returns where 2 breaks are back to back?
It seems that the interpretor is just reading the last tag.
Any info would be appreciated
Thanks tav
I'm currently using a formula to convert rtf to html and I'm also using the format "text interpretation set to html".
Formula works great-
Code:
stringvar output := {LONGDESCRIPTION.LDTEXT};
output := Replace(output,"<br />","<br>"); //get rid of line feed character
output := Replace(output,Chr(13) & Chr(10),"<br>"); //get rid of carriage return character
However my output goes from this-
SAFETY INFORMATION:<br /><br />OBSERVE ALL SAFETY STANDARDS AND PRECAUTIONS<br />VERIFY SIGN
To this-
SAFETY INFORMATION:<br><br>OBSERVE ALL SAFETY STANDARDS AND PRECAUTIONS<br>VERIFY SIGN
Which is good because when I format it to html, it views like this-
SAFETY INFORMATION:
OBSERVE ALL SAFETY STANDARDS AND PRECAUTIONS
VERIFY SIGN
However, after the word "INFORMATION" notice that there are 2 break tags. The data should appear like this-
SAFETY INFORMATION:
OBSERVE ALL SAFETY STANDARDS AND PRECAUTIONS
VERIFY SIGN
So now to my question, is there any way to display the 2 returns where 2 breaks are back to back?
It seems that the interpretor is just reading the last tag.
Any info would be appreciated
Thanks tav