Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

My Reports is not working at Oracle 9i iDS when i called from iDS Form

Status
Not open for further replies.
Jul 13, 2003
24
SA
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=&quot;report&quot; engineId=&quot;rwEng&quot; securityId=&quot;rwSec&quot;/>

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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top