Hi to everyone,
I work with Forms 10g on windows7(local working with OC4j),i have a form with a button that call a report,this is the code of the button:
declare
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(20);
BEGIN
repid := find_report_object('EMPS_BY_DEPTS');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,BATCH);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'pdf');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,'repetat');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_OTHER,'paramform=no');
v_rep := RUN_REPORT_OBJECT(repid);
rep_status := REPORT_OBJECT_STATUS(v_rep);
WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')
LOOP
rep_status := report_object_status(v_rep);
END LOOP;
IF rep_status = 'FINISHED' THEN
WEB.SHOW_DOCUMENT('/reports/rwservlet/getjobid'||substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server=repetat','_blank');
ELSE
message('Error when running report');
END IF;
END;
I create a report object in object navigator with name "EMPS_BY_DEPTS" with propertie filename = emps_by_depts.rdf.
i also created a server report with command wserver server=repetat
When i press button to call the report i get this famous FRM-41214: Unable to run report.
i tested the execution of report with rwservlet : http://acer-pc:8889/reports/rwservlet?report=emps_by_depts.rdf&userid=hr/hr@orcl&desformat=pdf&destype=cache&expiration=…
and it works fine.
Any idea and thanks