Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

RTF to HTML Crystal Reports 10 to oracle

Status
Not open for further replies.

tav1035

MIS
May 10, 2001
344
US
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-

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top