|
Plz check this .... calling report from form 9i&10g [message #193749 is a reply to message #193729] |
Tue, 19 September 2006 04:51   |
ashbraim
Messages: 3 Registered: September 2006 Location: Khalid Bin Al Waleed St.
|
Junior Member |

|
|
Declare
v_report_id Report_object;
vc_rePort_job_id varchar2(100);
vc_report_status varchar2(100);
Begin
V_REPORT_ID := FIND_REPORT_OBJECT('D:\SALES_REP\SALES_REP');
SET_REPORT_OBJECT_PROPERTY(V_REPORT_ID,REPORT_COMM_MODE, SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(V_REPORT_ID,REPORT_DESTYPE,CACHE);
SET_REPORT_OBJECT_PROPERTY(V_REPORT_ID,REPORT_DESFORMAT,'<HTML|HTMLCSS|PDF|RTF|XML|DELIMITED>');
SET_REPORT_OBJECT_PROPERTY(V_REPORT_ID,REPORT_SERVER, '<SHPROD>');
SET_REPORT_OBJECT_PROPERTY(V_REPORT_ID,REPORT_OTHER, 'SDATE='||:SDATE||'PARAMFORM=NO');
VC_REPORT_JOB_ID:=RUN_REPORT_OBJECT(V_REPORT_ID);
END;
i am getting error mesg. says
FRM-41219 Can not find report. invalid id.
|
|
|
|
|