calling oracle report from form builder

[imranmahmood_3]

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

[debasisdas]

You need to use the function RUN_REPORT_OBJECT

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;

[georgeskayal]

and then what i should do to call my report with a push button in oracle form builder 10.1.2.2

Put debasisdas' code in your When-Button-Pressed trigger.

[georgeskayal]

thanks but that code dosn't worked on my 10g 12.1.2.2 forms builder
this is what i use :
DECLARE
rep_url varchar2(2000);
BEGIN
rep_url:='/reports/rwservlet?'
||'&report=C:\Documents and Settings\Administrator\Desktop\Report\rep1.jsp'
||'&desformat=htmlcss&destype=cache'
||'&userid=tawkissa/tawkissa@xe';
WEB.SHOW_DOCUMENT(rep_url,'_blank');
END;

[deveshdashora]

Thanks "georgeskayal". The code is working......