acotunoaei
asked on
How to run a report from Forms 9i
I want to run a report from Forms using Oracle 9i. For that i wrote the following script and created the report object named(REPORT6)
When i run the script by pressing a button , in :agenti.nume( that is a text field in my form) is print repserver_116 (repserver is my Report Server). but , the report doesn't appear.I receive no other message.
declare
report_id Report_Object;
ReportServerJob VARCHAR2(100);
BEGIN
report_id:= find_report_object('REPORT 6');
SET_REPORT_OBJECT_PROPERTY (report_id ,REPORT_CO MM_MODE,SY NCHRONOUS) ;
SET_REPORT_OBJECT_PROPERTY (report_id ,REPORT_DE STYPE,CACH E);
SET_REPORT_OBJECT_PROPERTY (report_id ,REPORT_SE RVER,'reps erver');
SET_REPORT_OBJECT_PROPERTY (report_id ,REPORT_CO MM_MODE,SY NCHRONOUS) ;
SET_REPORT_OBJECT_PROPERTY (report_id ,REPORT_FI LENAME,'C: \Licenta\t est.rdf');
--SET_REPORT_OBJECT_PROPER TY(report_ id,REPORT_ OTHER,'p_d eptno='||: agenti.id_ agent||' paramform=no');
:agenti.nume:=run_report_o bject(repo rt_id);
END;
When i run the script by pressing a button , in :agenti.nume( that is a text field in my form) is print repserver_116 (repserver is my Report Server). but , the report doesn't appear.I receive no other message.
declare
report_id Report_Object;
ReportServerJob VARCHAR2(100);
BEGIN
report_id:= find_report_object('REPORT
SET_REPORT_OBJECT_PROPERTY
SET_REPORT_OBJECT_PROPERTY
SET_REPORT_OBJECT_PROPERTY
SET_REPORT_OBJECT_PROPERTY
SET_REPORT_OBJECT_PROPERTY
--SET_REPORT_OBJECT_PROPER
:agenti.nume:=run_report_o
END;
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Sorry for the delay.
The solution works.
Thanks a lot.
The solution works.
Thanks a lot.
http://www.oracle.com/technology/products/forms/pdf/277282.pdf