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

Formatting hyperlink on exported document

Status
Not open for further replies.

GCL2007

IS-IT--Management
Dec 11, 2007
167
US
Hi - I'm using Crystal 2016. We have Oracle database and my users have input a folder location stored in a BLOB field (\\server\folder\folder1) in one of the tables of my database.. I had a hard time getting it to display but finally did using a SQL Expression formula UTL_RAW.CAST_TO_VARCHAR2(DBMS_LOB.SUBSTR(doc_blob, 2000, 1)) . So I was happy to at least get it to display. Now I am hoping to get the hyperlink to work if they export it to excel or word document. Is there anyway I can do a normal export and have the field be linkable?
Thanks!
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top