2 Replies Latest reply: Apr 27, 2012 4:55 AM by HamidHelal RSS

    report is not calling from form??

    yash_08031983
      Hello experts,

      i have planing form.
      i am tring to calling a report base on plan_no in form. on executing from form a plan is fetching from db.
      form version 10g or db ver 10g.
      here is the run_report button code.

      DECLARE
      PL_ID PARAMLIST;

      BEGIN
           IF :BLK_PLAN_MST.PLAN_NO IS NOT NULL THEN
           PL_ID := GET_PARAMETER_LIST('D_PLAN');
           IF NOT ID_NULL(PL_ID) THEN
                DESTROY_PARAMETER_LIST(PL_ID);
           END IF;
           PL_ID := CREATE_PARAMETER_LIST('D_PLAN');
           MESS(:GLOBAL.PATH);
           ADD_PARAMETER(PL_ID,'PARAMFORM',TEXT_PARAMETER,'NO');
           ADD_PARAMETER(PL_ID,'COMP',TEXT_PARAMETER,:GLOBAL.COMPANY_GL_NAME);
           ADD_PARAMETER(PL_ID,'LOCN_CODE',TEXT_PARAMETER,:GLOBAL.COMPANY_GL_LOCN);
           ADD_PARAMETER(PL_ID,'PAR_PLAN_NO',TEXT_PARAMETER,:BLK_PLAN_MST.PLAN_NO);
           RUN_PRODUCT(REPORTS,lower('e:\project\rstr041.rdf'), synchronous, runtime, filesystem,pl_id,null);

           ELSE
                MESS('PLAN NUMBER CAN NOT BE BLANK....');
           END IF;
           
      END;

      thanks yash