| report calling [message #89621] |
Mon, 07 June 2004 04:03  |
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  |
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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
