Inserting Rich Text into Report

[tcbc]

I am using CR9 with an ODBC connection and the field I am trying to insert in the report is a varchar field. The text in the field is stored as rich text and when I try to report on the field, it comes into the report as rich text coding in front of and behind the text. I was hoping there was a way to just extract the text. Any help is greatly appreciated. Thank you!

 

[CR85user]

Right click the field - Click on: Format field -> Paragraph -> Change 'Text Interpretation' to 'RTF Text'

See if that gets you what you need.

'J

CR8.5 / CRXI - Discovering the impossible

 

[tcbc]

Thanks for the reply, but I tried that with no luck. Any other suggestions? Thanks!

 

[tcbc]

Nevermind, I believe I figured it out. Thanks!

 

[CarinaLister]

What was your solution? "I figured it out" doesn't help the rest of this community who might want to know. Thanks.


Carina Lister
Office of the City Prosecutor
In beautiful Long Beach, California
High Atop the Newport-Inglewood Fault
carina_lister@longbeach.gov