Home » Developer & Programmer » Forms » calling report from FORM 9i or 10g and Plz check this .... calling report from form 9i&10g (merg
icon8.gif  calling report from FORM 9i or 10g and Plz check this .... calling report from form 9i&10g (merg [message #193729] Tue, 19 September 2006 02:52 Go to next message
ashbraim
Messages: 3
Registered: September 2006
Location: Khalid Bin Al Waleed St.
Junior Member

Hi all

i have tried to call a report from form with some param. and i got the error says can not find redport.

after that i have tried the same report without any param. :

declare

report_id REPORT_OBJECT;
V_REP VARCHAR2(100);

begin

pl_id := Create_Parameter_List('SALESREP');


report_id := FIND_REPORT_OBJECT('D:\reports\SALESREP');


v_rep := run_report_object(report_id);
end;

and also i got the same error meassage

Please help

Regards

Plz check this .... calling report from form 9i&10g [message #193749 is a reply to message #193729] Tue, 19 September 2006 04:51 Go to previous messageGo to next message
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.
icon14.gif  Re: Plz check this .... calling report from form 9i&10g [message #193928 is a reply to message #193749] Wed, 20 September 2006 00:26 Go to previous messageGo to next message
ingalesd
Messages: 10
Registered: June 2006
Location: Mumbai
Junior Member

under the reports node of forms object navigator
create a report object first
then if the report object name is 'report4'

then use find_report_object('report4') instead of
giving path (find_report_object('d:\....'))

it will work!!!

regards
Shantaram
Re: please check this .... calling report from form 9i&10g [message #345650 is a reply to message #193928] Thu, 04 September 2008 06:33 Go to previous message
manudu20
Messages: 45
Registered: August 2008
Location: Mumbai
Member

Hi,
I am also getting problem in find_report_object.

Can u tell me while making report in report node
What are the parameters we have to fill and what is the use
Filename ?
Executionmode?
report destination type ?
destination format ?
report server ?
Previous Topic: How to get data in multi item blocks when linked to single item block
Next Topic: ACTIVE AND INACTIVE BUTTON.......trigger fir after each charcter and MADA (merged)
Goto Forum:
  


Current Time: Wed Dec 07 20:15:54 CST 2016

Total time taken to generate the page: 0.09077 seconds