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!
Thanks!