Home » Developer & Programmer » Forms » run report in forms 11 (form 11)
run report in forms 11 [message #575796] Mon, 28 January 2013 00:47 Go to next message
alijeyan
Messages: 184
Registered: January 2007
Location: IRAN
Senior Member
I have a report and save in D:\my_app\report1.rdf
i want call report in a form ;
i write this code in When_button_pressed

declare 
  v_rep varchar2(100);
  rep_id  report_object;
begin
  rep_id:=find_report_object('D:\my_app\report1.rdf');
--  or this
-- rep_id:=find_report_object('D:\my_app\report1.jsp'); 
  v_rep:=run_report_object(rep_id);
end;


when i run form in my browser this error Occured;

FRM41219 : can not find report , invalid Id
Re: run report in forms 11 [message #575800 is a reply to message #575796] Mon, 28 January 2013 01:01 Go to previous messageGo to next message
Littlefoot
Messages: 21807
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Does the report exist in C:\MY_APP directory on the application server?
Re: run report in forms 11 [message #575815 is a reply to message #575800] Mon, 28 January 2013 02:02 Go to previous messageGo to next message
alijeyan
Messages: 184
Registered: January 2007
Location: IRAN
Senior Member
No , I use weblogic in a local system .
Re: run report in forms 11 [message #575818 is a reply to message #575815] Mon, 28 January 2013 02:23 Go to previous messageGo to next message
ruthran
Messages: 2
Registered: January 2013
Location: bangalore
Junior Member

Hi, Have to create a report object in the Forms builder ?...

Kind Regards
Ruthran
Re: run report in forms 11 [message #575831 is a reply to message #575818] Mon, 28 January 2013 05:01 Go to previous messageGo to next message
alijeyan
Messages: 184
Registered: January 2007
Location: IRAN
Senior Member
no , I create report By report biulder 11 .
Re: run report in forms 11 [message #575840 is a reply to message #575831] Mon, 28 January 2013 05:51 Go to previous messageGo to next message
cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester
Senior Member
Report is not the same as report object.
Report object is an object created in forms to describe the report you want to run.
Going by your answer I'd say you haven't created one.
Open up form builder help, read up on report objects, then set one up.
Re: run report in forms 11 [message #576262 is a reply to message #575840] Sat, 02 February 2013 01:53 Go to previous messageGo to next message
alijeyan
Messages: 184
Registered: January 2007
Location: IRAN
Senior Member
can I use RUN_PRODUCT in forms 11 to run My reports ?
Re: run report in forms 11 [message #576266 is a reply to message #576262] Sat, 02 February 2013 02:22 Go to previous messageGo to next message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

No.
Web.Show_Document();


Regards,
Irfan
Re: run report in forms 11 [message #576274 is a reply to message #576266] Sat, 02 February 2013 04:17 Go to previous messageGo to next message
alijeyan
Messages: 184
Registered: January 2007
Location: IRAN
Senior Member
I have a report . (My_rep.rep & My_rep.RDF) . please send code for WHEN_BUTTON_PRESSED to call my report with
Web.Show_Document()
Re: run report in forms 11 [message #576276 is a reply to message #576274] Sat, 02 February 2013 04:24 Go to previous message
ranamirfan
Messages: 535
Registered: January 2006
Location: Pakistan / Saudi Arabia
Senior Member

Search Web.Show_Document you'll find out many examples in Forum.
Previous Topic: Avoid Duplication in three tables
Next Topic: queries on long/lob items
Goto Forum:
  


Current Time: Thu Apr 18 20:12:15 CDT 2024