Report to Report Calling in Oracle Reports 11g

 

field Name PO_NO Press f11 on PO_NO then put the following Code

function F_igp_no3FormatTrigger return boolean is

txn number;

r_url varchar2(500);

r_path varchar2(500);

begin

select url, path into r_url, r_path from smf_reports where rownum = 1 ;

  select txn_ide into txn from inv_igp_m where igp_no = :igp_no;

srw.set_hyperlink(r_url||'/reports/rwservlet?cmdkey=skey&report='||r_path||'rpt_igp.rdf&destype=cache&desformat=PDF&TXNIDE='||txn);

  return (TRUE);

end;