Oracle

calling oracle report from form builder

Please support our Oracle advertiser: PostgreSQL or MySQL? Compare and contrast the two most popular open source databases

•

Join Date: Jun 2009

Posts: 1

Reputation: imranmahmood_3 is an unknown quantity at this point

Solved Threads: 0

imranmahmood_3 imranmahmood_3 is offline

Offline

Newbie Poster

calling oracle report from form builder

Jun 20th, 2009

how to call oracle report using form builder on which command button.If i press command button report should be run.

•

Join Date: Feb 2007

Posts: 2,093

Reputation: debasisdas will become famous soon enough

Solved Threads: 127

debasisdas debasisdas is offline

Offline

Postaholic

Re: calling oracle report from form builder

Jun 24th, 2009

You need to use the function RUN_REPORT_OBJECT

 Help with Code Tags 
 Oracle Syntax (Toggle Plain Text) 
DECLARE 
	repid REPORT_OBJECT; 
	v_rep  VARCHAR2(100); 
	rep_status VARCHAR2(20); 
BEGIN 
	repid := find_report_object('report4'); 
	v_rep := RUN_REPORT_OBJECT(repid); 
	...... 
END;
DECLARE 
	repid REPORT_OBJECT; 
	v_rep  VARCHAR2(100); 
	rep_status varchar2(20); 
BEGIN 
	repid := find_report_object('report4'); 
	v_rep := RUN_REPORT_OBJECT(repid); 
	...... 
END;