Just place a text in a report and write this code in pl/sql editor and you can call another report in a main report (calling one report to another report)
function U_sub1FormatTrigger return boolean is
begin
SRW.SET_HYPERLINK('http://000.000.00.00:0000/reports/rwservlet?LWF+report=LWFEmpCasSubscription+DESTYPE=CACHE+DESFORMAT=pdf+SERVER=repserv'||
'+P_COMPANY_CODE='||''''||:P_COMPANY_CODE||''''||
'+P_MEMCOMPANY='||''''||:membercompanycode||''''||
'+P_CATEGORY='||''''||:cf_category||''''||
'+P_EMP='||''''||:cf_pemp||''''||
'+P_TODT='||''''||:P_TODT||'''');
end;
function U_sub1FormatTrigger return boolean is
begin
SRW.SET_HYPERLINK('http://000.000.00.00:0000/reports/rwservlet?LWF+report=LWFEmpCasSubscription+DESTYPE=CACHE+DESFORMAT=pdf+SERVER=repserv'||
'+P_COMPANY_CODE='||''''||:P_COMPANY_CODE||''''||
'+P_MEMCOMPANY='||''''||:membercompanycode||''''||
'+P_CATEGORY='||''''||:cf_category||''''||
'+P_EMP='||''''||:cf_pemp||''''||
'+P_TODT='||''''||:P_TODT||'''');
end;
0 comments:
Post a Comment