Syntax of run_report_object

[MichaelI]

Hi,
I am migrating Report6 reports to Report9, and the reports are called from a menu using run_product which is not supported in Report9. I believe I need to use run_report_object but need some help with it.
Has anyone gone through this exercise, and can offer any assistance?
Many thanks.

 

[KULJEETSINGH]

HI
USE THIS SYNTAX

declare
report_id Report_Object;
report_job_id VARCHAR2(100);
BEGIN
report_id:= find_report_object('report_node');
*******************************
--NOTE <REPORT_NODE> IS NOT A REPORT NAME
--IT IS A REPORT OBJECT IN OBJECT NAVIGATION OF FORM UNDET - --IT U GIVE REPORT NAME
*******************************
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_EXECUTION_MODE,BATCH);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_COMM_MODE,ASYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_DESTYPE,PRINTER);
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_SERVER,'<REPORT SERVER NAME>');
SET_REPORT_OBJECT_PROPERTY(report_id,REPORT_OTHER,'PARAM1='||:code1||' '||'PARAM2'||:code2);
--REPORT_OTHER IS OPTIONAL FOR PASSING PARAMETR
END;

 

[KULJEETSINGH]

SORRY USE ONE MORE LINE BEFORE END;

report_JOB_ID:=run_report_object(report_id);

THIS LINE USE AT THE END (BEFORE END STATEMENT)

 

[poorjokein]

hello I am priyesh. A New Comer in Oracle IDS.
I have a problem of calling reports from form
.I used the syntax given by kuldeep, but still
error occurs.
&quot;you haven't specified the name of the report &quot;

though I tried every possible permutations and combinations I could not made it till now.
Please help me out.
priyesh_jaiswal2000@yahoo.com