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

Recommended Answers

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;
Jump to Post

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

Jump to Post

All 5 Replies

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;
commented: riiiiiiiiight +6

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

Member Avatar

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

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;

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

Be a part of the DaniWeb community

We're a friendly, industry-focused community of 1.20 million developers, IT pros, digital marketers, and technology enthusiasts learning and sharing knowledge.