Problem with web reports !
From: tom <tomdh_at_company.be>
Date: 19 Mar 2002 01:46:13 -0800
Message-ID: <a9a9ac7e.0203190146.235fc388_at_posting.google.com>
I have oracle 9i installed on a linux server and i'm working with forms builder 6i.
I'm running my forms as a web based form. Now i want to run a report when i click on a button and use the data from the form. In windows, without using web based forms it works. But it doesn't work as web based. It gives 4 errors about not finding my id.
This is the code i use:
report_id Report_Object;
report_job_id VARCHAR2(200);
END; It seems from the errors i get he can't find my report_id. I hope someone can help me with this
Date: 19 Mar 2002 01:46:13 -0800
Message-ID: <a9a9ac7e.0203190146.235fc388_at_posting.google.com>
I have oracle 9i installed on a linux server and i'm working with forms builder 6i.
I'm running my forms as a web based form. Now i want to run a report when i click on a button and use the data from the form. In windows, without using web based forms it works. But it doesn't work as web based. It gives 4 errors about not finding my id.
This is the code i use:
DECLARE
uif VARCHAR(80); repid REPORT_OBJECT; v_rep VARCHAR2(100); pl_id Paramlist;
report_id Report_Object;
report_job_id VARCHAR2(200);
BEGIN
uif:=Get_Application_property(USER_INTERFACE);
if uif = 'WEB' then
report_id:= FIND_REPORT_OBJECT('JOB_REPORT');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_EXECUTION_MODE,'batch');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESTYPE,'file');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESNAME,'c:\temp\HETBESTAND.html');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESFORMAT,'html');
Web.Show_Document('http://oracy:7777/dev60temp/HETBESTAND.html','_blank');
else
repid := find_report_object('JOB_HISTORY');
v_rep := RUN_REPORT_OBJECT(repid);
end if;
END; It seems from the errors i get he can't find my report_id. I hope someone can help me with this
Thx Received on Tue Mar 19 2002 - 10:46:13 CET