FRM-41214 Unable to run report
468734Nov 4 2006 — edited Nov 6 2006Hi all,
I have a parameter form where user enter to parameter and click OK button to call out a report.
However I got this error: FRM-41214 Unable to run report
My code for the WHEN-BUTTON-PRESSED button as below:
Please help!! TQ
DECLARE
pl_id ParamList;
repid REPORT_OBJECT;
v_rep varchar2(100);
v_server VARCHAR2(100);
rep_status varchar2(100);
v_host VARCHAR2(100);
BEGIN
v_server := 'rep_user-faf4251ef8';
v_host := 'user-faf4251ef8:8889';
pl_id := Get_Parameter_List('tmpdata');
IF NOT Id_Null(pl_id) THEN
Destroy_Parameter_List( pl_id );
END IF;
pl_id := Create_Parameter_List('tmpdata');
Add_Parameter(pl_id,'FROMDT',TEXT_PARAMETER,:LS.FRDT);
Add_Parameter(pl_id,'TODATE',TEXT_PARAMETER,:LS.TODT);
Add_Parameter(pl_id,'STAFFID',TEXT_PARAMETER,:LS.STAFFID);
ADD_PARAMETER(pl_id,'TITLE',TEXT_PARAMETER,:LS.TITLE);
repid := find_report_object('rep1');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_FILENAME,'R1');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'HTML');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,v_server);
--SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,'paramform=YES');
v_rep := RUN_REPORT_OBJECT(repid, pl_id);
rep_status := REPORT_OBJECT_STATUS(v_rep);
WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')
LOOP
rep_status := report_object_status(v_rep);
message('Running');
END LOOP;
IF rep_status = 'FINISHED' or rep_status is NULL THEN
WEB.SHOW_DOCUMENT('http://'||v_host||'/reports/rwservlet/getjobid'||substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server='||v_server,'_b lank');
ELSE
null;
END IF;
END;