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 Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Reports 9.0.4 - how to display .rtf stored in DB column

Status
Not open for further replies.

mikalw

Technical User
Nov 19, 2005
1
0
0
US

Background: We are migrating a legacy PC-based client/server system to a web system. We are building reports using Reports 9.0.4. The legacy system stored miscellaneous notes data in .rtf format in a LONG column in the database. The data has been migrated to the new system and is currently being stored as CLOB. The display of the data in the CLOB field shows the RTF contol groups and words which is not desired. We have the control to modify the migration process to store this data is a different way (e.g. BLOBs, even BFILEs) if that is advantageous. We have considered stripping out the .rtf formatting controls as a fallback plan but the customer would like to retain that formatting.

Question: Is there a way to display the .rtf data stored in a database column in a report while retaining the .rtf formatting?

 
Store RTFs as BLOBs. In the report data model, in this BLOB column's properties choose Read from File --> Yes, File Format --> OLE 2
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top