frm-41214 : Unable to run report [message #590697] |
Mon, 22 July 2013 05:59 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](//www.gravatar.com/avatar/b5f65e3b163574315f7901bb2dc6f3c9?s=64&d=mm&r=g) |
samir2012
Messages: 10 Registered: May 2013
|
Junior Member |
|
|
Hi,
I tried to run the report from form in oracle forms 10g,
The following error is coming when I click on Report Button.
frm-41214: unable to run report.
Please help.
Thanks & Regards,
Samir
|
|
|
Re: frm-41214 : Unable to run report [message #590703 is a reply to message #590697] |
Mon, 22 July 2013 06:22 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
![](//www.gravatar.com/avatar/b5f65e3b163574315f7901bb2dc6f3c9?s=64&d=mm&r=g) |
samir2012
Messages: 10 Registered: May 2013
|
Junior Member |
|
|
I am calling report through Run_Report_object.
Following is my code
DECLARE
v_repid REPORT_OBJECT;
v_rep VARCHAR2(100);
v_rep_status VARCHAR2(100);
--v_param VARCHAR2(200) := NULL;
v_valor VARCHAR2(200);
v_url VARCHAR2(2000);
v_repserver varchar2(200) := 'rep_pbannerinb1';
v_report varchar2(100) := '/u01/banner/inb/TEST/reports/rdf/GZGCDSC.rdf';
BEGIN
v_repid := FIND_REPORT_OBJECT('REPORT206');
SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_FILENAME, v_report);
SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_EXECUTION_MODE, BATCH);
SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_COMM_MODE, SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_DESTYPE, cache);
SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_DESFORMAT, 'HTMLCSS' );
SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_DESNAME, v_report);
SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_SERVER, v_repserver);
SET_REPORT_OBJECT_PROPERTY(v_repid, REPORT_OTHER, 'paramform=no'||:DUAL.GZGCDSC_ID);
v_rep := RUN_REPORT_OBJECT(v_repid);
v_rep_status := REPORT_OBJECT_STATUS(v_rep);
WHILE v_rep_status IN ('RUNNING','OPENING_REPORT','ENQUEUED') LOOP
v_rep_status := REPORT_OBJECT_STATUS(v_rep);
END LOOP;
IF v_rep_status = 'FINISHED' THEN
message(v_rep);
message(v_rep);
WEB.SHOW_DOCUMENT(v_url||'/reports/rwservlet/getjobid'||
SUBSTR(v_rep, INSTR(v_rep,'_', -1)+1)||'?'||'server='||v_repserver, '_blank');
END IF;
END;
|
|
|
|
|
|
|