Home » Developer & Programmer » Reports & Discoverer » how to call reports from forms (developer 10G)
how to call reports from forms [message #381320] Fri, 16 January 2009 05:54 Go to next message
athar.fitfd@hotmail.com
Messages: 193
Registered: October 2007
Location: pakistan
Senior Member
Hi dear.

i want to call reports 10g from forms 10g.


what are pre-requisits for it.

application server installation and other configurations


please tell me.


bye

Athar
Re: how to call reports from forms [message #381485 is a reply to message #381320] Sat, 17 January 2009 02:59 Go to previous message
javed.khan
Messages: 340
Registered: November 2006
Location: Banglore
Senior Member

You will have to use WEB.SHOW_DOCUMENT in your Print or Run Button
for e.g.

Declare
repid      REPORT_OBJECT;
v_rep      VARCHAR2(1000);
rep_status VARCHAR2(20);
 
BEGIN
repid := find_report_object('YOURREPORTNAME');
 
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_EXECUTION_MODE,BATCH);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_COMM_MODE,SYNCHRONOUS);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESTYPE,CACHE);
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_DESFORMAT,'YOURREPORTEXTENSION');
SET_REPORT_OBJECT_PROPERTY(repid,REPORT_SERVER,'servername');
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://<server>:<port>/reports/rwservlet/showjobs?server=servername' ||
 substr(v_rep,instr(v_rep,'_',-1)+1)||'?'||'server=servername','_blank');
 
 ELSE
 
 message('Error when running report');
 
 END IF;
 END;


Javed
Previous Topic: Report special numbering
Next Topic: How to register Discoverer report as a concurrent program in apps?
Goto Forum:
  


Current Time: Tue Dec 06 16:22:08 CST 2016

Total time taken to generate the page: 0.13801 seconds