OraFAQ Forum: Forms » how to run reports on 9i from a form?

Home » Developer & Programmer » Forms » how to run reports on 9i from a form?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

how to run reports on 9i from a form? [message #83668]

Sun, 23 November 2003 08:20

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;

Report message to a moderator

Re: how to run reports on 9i from a form? [message #83676 is a reply to message #83668]

Mon, 24 November 2003 07:53

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.

Report message to a moderator

Re: how to run reports on 9i from a form? [message #83677 is a reply to message #83668]

Mon, 24 November 2003 21:21

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;

Report message to a moderator

Re: how to run reports on 9i from a form? [message #83701 is a reply to message #83677]

Mon, 01 December 2003 07:36

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.

Report message to a moderator

Re: how to run reports on 9i from a form? [message #83721 is a reply to message #83668]

Wed, 03 December 2003 17:26

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.

Report message to a moderator