Home » Developer & Programmer » Forms » call web report from oracle form 6i (Oracle Forms 6i)
call web report from oracle form 6i [message #354769] Tue, 21 October 2008 03:17 Go to next message
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
Re: call web report from oracle form 6i [message #354921 is a reply to message #354769] Wed, 22 October 2008 00:05 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: call web report from oracle form 6i [message #355047 is a reply to message #354921] Wed, 22 October 2008 06:44 Go to previous messageGo to next message
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');

Re: call web report from oracle form 6i [message #355366 is a reply to message #355047] Thu, 23 October 2008 18:26 Go to previous messageGo to next message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Re: call web report from oracle form 6i [message #355479 is a reply to message #355366] Fri, 24 October 2008 06:15 Go to previous messageGo to next message
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
Re: call web report from oracle form 6i [message #356206 is a reply to message #355479] Wed, 29 October 2008 23:56 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: Prompt a message before closing a form
Next Topic: data not displaying
Goto Forum:
  


Current Time: Sat Dec 03 17:49:04 CST 2016

Total time taken to generate the page: 0.10293 seconds