Link to home
Start Free TrialLog in
Avatar of acotunoaei
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('REPORT6');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESTYPE,CACHE);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_SERVER,'repserver');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_FILENAME,'C:\Licenta\test.rdf');
--SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_OTHER,'p_deptno='||:agenti.id_agent||' paramform=no');
:agenti.nume:=run_report_object(report_id);
END;
ASKER CERTIFIED SOLUTION
Avatar of Helena Marková
Helena Marková
Flag of Slovakia image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
See this document. It's very useful for what you are trying.
http://www.oracle.com/technology/products/forms/pdf/277282.pdf
Avatar of acotunoaei
acotunoaei

ASKER

Sorry for the delay.

The solution works.

Thanks a lot.