rashidquadri
MIS
Hi *
I am new in Oracle iDS tools . I installed iDS at a PC . and did some configuration
to run iDS on explorer.
My problem is when I try to run report from a Form then reports did not call from
Form even no any Error is showing. I do not what is problem because no any error
Show but when I run report though this web address then this report is runing in explorer.
my Form is working Smothly.i Did Configure this File and write code
on a button to call a reports.
registry Path
FORMS90_PATH=D:\RQ_SOFT\FA_ADMIN
REPORTS_PATH=D:\RQ_SOFT\FA_ADMIN
formsweb.conf
workingDirectory=D:/RQ_SOFT\FA_ADMIN
### envFile=default.env
envFile=E:\orant\forms90\server\default.env
default.env
FORMS90_PATH=D:/RQ_SOFT\FA_ADMIN
REPORTS_PATH=D:/RQ_SOFT\FA_ADMIN
rwservlet.properties
SINGLESIGNON=YES
report server/report service configuration file
repsrv4.conf
<job jobType="report" engineId="rwEng" securityId="rwSec"/>
this is my code at when-button-press trigger
DECLARE
repid Report_Object;
v_rep Varchar2(100);
rep_status varchar2(20);
begin
repid:=find_report_object('REPORT36');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,BATCH);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'html');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,'Repsrv4');
v_rep:=run_report_object(repid);
rep_status:=run_report_object(v_rep);
WHILE rep_status in ('RUNNING','OPEN_REPORT','ENQUEUED') LOOP
rep_status:=run_report_object(v_rep);
END LOOP;
if rep_status='FINISHED' THEN
WEB.SHOW_DOCUMENT(' ELSE
MESSAGE('Eroor when running report.');
END IF;
END;
Please give me idea where I did mistake.
Thanks in Advance
Raj
I am new in Oracle iDS tools . I installed iDS at a PC . and did some configuration
to run iDS on explorer.
My problem is when I try to run report from a Form then reports did not call from
Form even no any Error is showing. I do not what is problem because no any error
Show but when I run report though this web address then this report is runing in explorer.
my Form is working Smothly.i Did Configure this File and write code
on a button to call a reports.
registry Path
FORMS90_PATH=D:\RQ_SOFT\FA_ADMIN
REPORTS_PATH=D:\RQ_SOFT\FA_ADMIN
formsweb.conf
workingDirectory=D:/RQ_SOFT\FA_ADMIN
### envFile=default.env
envFile=E:\orant\forms90\server\default.env
default.env
FORMS90_PATH=D:/RQ_SOFT\FA_ADMIN
REPORTS_PATH=D:/RQ_SOFT\FA_ADMIN
rwservlet.properties
SINGLESIGNON=YES
report server/report service configuration file
repsrv4.conf
<job jobType="report" engineId="rwEng" securityId="rwSec"/>
this is my code at when-button-press trigger
DECLARE
repid Report_Object;
v_rep Varchar2(100);
rep_status varchar2(20);
begin
repid:=find_report_object('REPORT36');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,BATCH);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'html');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,'Repsrv4');
v_rep:=run_report_object(repid);
rep_status:=run_report_object(v_rep);
WHILE rep_status in ('RUNNING','OPEN_REPORT','ENQUEUED') LOOP
rep_status:=run_report_object(v_rep);
END LOOP;
if rep_status='FINISHED' THEN
WEB.SHOW_DOCUMENT(' ELSE
MESSAGE('Eroor when running report.');
END IF;
END;
Please give me idea where I did mistake.
Thanks in Advance
Raj