My question (thread766-1375984 ) did not get resolved via posting, but I did eventually find the answer.
This is the SQL code that casts a BLOB field to printable text:
UTL_RAW.CAST_TO_VARCHAR2("MEMOS"."THEMEMO")
Thought someone might find this useful.
I need to print a Crystal Report XI to an Epson POS printer. The report is complete, and it prints well, but I need to be able to force the paper to cut after each record is complete. I have been told that I need to create a formula field and place it in the report footer. I found code...
In a Crystal XI report, I need to use tables from two data sources. When I bring in the second source with an external join, I lose the ability to select distinct records. Is there any way to do this?
I am working with an Oracle database that contains a BLOB with text only data. When I insert this field into a Crystal Reports XI report, the data does not show up. I am sure the text is there. Attempts to convert the BLOB to text by creating a formula field (To_Text({GSP_BOOKING.NOTES}) give...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.