Home » Developer & Programmer » Reports & Discoverer » report calling
report calling [message #89621] Mon, 07 June 2004 04:03 Go to next message
revathi
Messages: 6
Registered: July 2000
Junior Member
hai friends
how to call a report from another report with passing parameters
Re: report calling [message #89623 is a reply to message #89621] Mon, 07 June 2004 05:41 Go to previous message
subhasish
Messages: 33
Registered: May 2000
Member
Hello
Here I have given an example , hope this is what u want..

Create a button on the layout with button behaviour type pl/sql and write the code in pl/sql trigger.

procedure U_moreButtonAction is
reg_val varchar2(150);
begin
reg_val := 'C:REPORTScalling_rpt.RDF';
srw.RUN_report('report='||reg_val||'
paramform=no
comp_code="'||:comp_code||'"
emp_code="'||:emp_code||'"');
exception
when srw.run_report_failure then
srw.message(1002,'Could not run detail report');
when others then
null;
end;

comp_code and emp_code are the parameters that is being passed to the calling report.

with rgds
subhasish
Previous Topic: Layout question
Next Topic: Urgent.Report printing more than one page
Goto Forum:
  


Current Time: Mon Mar 04 12:45:16 CST 2024