hi,
Im working on custom forms and reports upgrade from 11i to r12.
My forms are working fine. I m trying to call a report from forms menu.
I have button named reports in forms, when i click my report has to be called. I heard in r12 , there is no report server. I found in config files, its an IN PROCESS SERVER.
when i run in forms builder local machine, giving my machine name say -http://sys111:8889/reports/rwservlet/?with my report name-i get output and report status.
But when i try to run from r12 server, giving my hostname,its shows page not found.
In forms plsql editor, i used run_report_object procedure
and use web.show_document ('/reports/rwservlet/getjobid='||vc_report_job_id||'?_blank');
is rwservlet applicable in r12? i have both forms and reports server together as application server. wat is been wrong? somthing els has to configured in server end.Please advice.
here is my code
[PROCEDURE RUN_REPORT_OBJECT_PROC
(vc_reportname Varchar2,
vc_reportserver varchar2,
vc_runformat varchar2) IS
v_report_id Report_Object;
vc_report_job_id VARCHAR2(100); /* unique id for each Report request */
vc_rep_status VARCHAR2(20); /* status of the Report job */
BEGIN
v_report_id:= FIND_REPORT_OBJECT(vc_reportname);
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESTYPE,CACHE);
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_DESFORMAT,vc_runformat);
SET_REPORT_OBJECT_PROPERTY(v_report_id,REPORT_SERVER,vc_reportserver);
vc_report_job_id:=RUN_REPORT_OBJECT(v_report_id);
vc_rep_status := REPORT_OBJECT_STATUS(vc_report_job_id);
IF vc_rep_status='FINISHED' THEN
web.show_document ('/devcgi/rwcgi.exe/getjobid='||vc_report_job_id||'?server='||vc_reportserver,'_blank');
--i changed the command to reports/rwservlet/---
ELSE
message ('Report failed with error message '||vc_rep_status);
END IF;
END;
]
can you pls advice..how to run the report from forms?
Thanks in advance.
