OraFAQ Forum: Forms » call web report from oracle form 6i

Home » Developer & Programmer » Forms » call web report from oracle form 6i (Oracle Forms 6i)

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

call web report from oracle form 6i [message #354769]

Tue, 21 October 2008 03:17

joelleghazal
Messages: 3
Registered: October 2008

Junior Member

I am trying to run web report from oracle forms 6i
i have created a form with a "dummy" report that has as configuration a report "test.rdf", cache, HTML and report server name as it appears in oracle AS "repaspb".
i used the following code in my form:

DECLARE
v_url varchar2(200);
v_url2 varchar2(2000);

repid REPORT_OBJECT;
v_rep VARCHAR2(100);
rep_status VARCHAR2(50);

BEGIN
repid := find_report_object('DUMMY');
v_rep := RUN_REPORT_OBJECT(repid);
rep_status := REPORT_OBJECT_STATUS(v_rep);

WHILE rep_status in ('RUNNING','OPENING_REPORT','ENQUEUED')
LOOP
rep_status := report_object_status(v_rep);
END LOOP;
IF rep_status = 'FINISHED' THEN
WEB.SHOW_DOCUMENT('http://reportserver)_IP:Port/reports/rwservlet/getjobid'||
substr(v_rep,instr(v_rep,'_',-1)+1),'_blank');
ELSE
message('Error when running report');
END IF;
END;

when running the script i am getting the following error:
FRM-41213: unable to connect to the report server repaspb.

i ping to the server and it is requesting
i have try the report on the web and it is working

how could i fix this problem?

Thank you,
Joelle Ghazal

Report message to a moderator

Re: call web report from oracle form 6i [message #354921 is a reply to message #354769]

Wed, 22 October 2008 00:05

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Do not use the 'RUN_REPORT_OBJECT' command, just use the 'WEB.SHOW_DOCUMENT' command. That is, remove the while loop' and the 'if' test as well.

David

Report message to a moderator

Re: call web report from oracle form 6i [message #355047 is a reply to message #354921]

Wed, 22 October 2008 06:44

joelleghazal
Messages: 3
Registered: October 2008

Junior Member

how to get the jobid of the report, if i didn't use RUN_REPORT_OBJECT?

how it should be my code?

Sample:
DECLARE
repid REPORT_OBJECT;
BEGIN
repid := find_report_object('DUMMY');

WEB.SHOW_DOCUMENT('http://remote_server:port/reports/rwservlet/getjobid'||
substr(v_rep,instr(v_rep,'_',-1)+1),'_blank');

END;

WEB.SHOW_DOCUMENT('http://remote_server:port/reports/rwservlet/??????????????),'_blank');

Report message to a moderator

Re: call web report from oracle form 6i [message #355366 is a reply to message #355047]

Thu, 23 October 2008 18:26

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

And why would you want it? The report runs, it is displayed or printed, and then it is removed.

David

Report message to a moderator

Re: call web report from oracle form 6i [message #355479 is a reply to message #355366]

Fri, 24 October 2008 06:15

joelleghazal
Messages: 3
Registered: October 2008

Junior Member

please can you post here the code that i should use.

cause in my last statement i should get the jobid

Report message to a moderator

Re: call web report from oracle form 6i [message #356206 is a reply to message #355479]

Wed, 29 October 2008 23:56

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Working from memory: I believe that there is a system table that contains the list of report server jobs. Use the 'manager' on the Application Server or Database Server to see all the tasks that have been run. When you have the list of reports on your screen, use a tool like TOAD to display the recently executed database queries. This query will tell you the table/view that contains the list of reports. Use this information to build your own query to determine the last report run by this user.

David

Report message to a moderator

Previous Topic:	Prompt a message before closing a form
Next Topic:	data not displaying

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 00:37:43 CST 2025