Does anyone know how can I display the text data from an Oracle BLOB column onto a webfocus report directly without converting it and load it as a varchar2 column first?

Using the pass-thru method try
select
DBMS_LOB.SUBSTR(C.CLOSEDESC, 500, 1) CLOSEDESC
from ...
where .....