Home » Developer & Programmer » Forms » how to run reports on 9i from a form?
how to run reports on 9i from a form? [message #83668] Sun, 23 November 2003 08:20 Go to next message
Nello
Messages: 5
Registered: November 2003
Junior Member
i have a problem in oracle 9i Developer. Every time i use this commands below
an error appears --> ''cannot find report id''
this is the only allowable command to run a report because 9i says it does not support run product.

Trigger: When Button Pressed
declare
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(20);

begin
repid := FIND_REPORT_OBJECT('ProductRep.jsp');
v_rep := RUN_REPORT_OBJECT('repid');
end;
Re: how to run reports on 9i from a form? [message #83676 is a reply to message #83668] Mon, 24 November 2003 07:53 Go to previous messageGo to next message
magnetic
Messages: 324
Registered: January 2003
Senior Member
it guess your report path is not set in the registry.
if forms and reports are in the same directory then no problem should be occure.
Re: how to run reports on 9i from a form? [message #83677 is a reply to message #83668] Mon, 24 November 2003 21:21 Go to previous messageGo to next message
Nello
Messages: 5
Registered: November 2003
Junior Member
The forms and reports directory:
FORMS-->C:oracle9iDSora92iDSforms90
REPORTS-->C:oracle9iDSora92iDSREPOS61

My reports are in '.jsp' format.
what else do you suggest?

In the OBJECT NAVIGATOR in forms developer
i added a report w/c is in the name 'REPORT26',
should i put it inside the repid := FIND_REPORT_OBJECT('reports26')??

Trigger: When Button Pressed
declare
repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(20);

begin
repid := FIND_REPORT_OBJECT('ProductRep.jsp');
v_rep := RUN_REPORT_OBJECT('repid');
end;
Re: how to run reports on 9i from a form? [message #83701 is a reply to message #83677] Mon, 01 December 2003 07:36 Go to previous messageGo to next message
magnetic
Messages: 324
Registered: January 2003
Senior Member
FORMS-->C:oracle9iDSora92iDSforms90
REPORTS-->C:oracle9iDSora92iDSREPOS61
are these your development paths (should be) or the path of the oracle applications (should not be your development path)?
you should have registrykey for developmentpaths of forms and reports
e.g. forms60_path for a formdevelpment with forms 6 should contains a path like c:myforms.
Re: how to run reports on 9i from a form? [message #83721 is a reply to message #83668] Wed, 03 December 2003 17:26 Go to previous messageGo to next message
Lars O Sjöström
Messages: 25
Registered: May 1999
Junior Member
You have to define a report object in Forms to. You find that in your navigator in Forms. "Reports" it says.

There you define what file to run as a report. At least this is the way if you run a Oracle Report report.
Re: simple code to run a report on 9i Form? [message #83730 is a reply to message #83701] Wed, 03 December 2003 18:42 Go to previous messageGo to next message
Nello
Messages: 5
Registered: November 2003
Junior Member
Can you guys give a simple code to run a report from
9i on a FORM?
Re: simple code to run a report on 9i Form? [message #83957 is a reply to message #83730] Fri, 09 January 2004 02:19 Go to previous message
Deepak
Messages: 111
Registered: December 1999
Senior Member
UN_PRODUCT(REPORTS,file_nm,SYNCHRONOUS,RUNTIME,FILESYSTEM,null);
Previous Topic: Where do i get navigaor.pll
Next Topic: column alignment with select statement
Goto Forum:
  


Current Time: Thu Mar 28 14:30:07 CDT 2024