Friday 26 September 2014

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;

0 comments:

Post a Comment

Copyright © ORACLE-FORU - SQL, PL/SQL and ORACLE D2K(FORMS AND REPORTS) collections | Powered by Blogger
Design by N.Design Studio | Blogger Theme by NewBloggerThemes.com