Results 1 to 2 of 2
  1. #1
    Join Date
    Feb 2004
    Location
    Kuwait
    Posts
    38

    Question Unanswered: Refering parameters from a form to reports

    Hi guys
    Please go through the following PL/SQL code I attached with a form, to pass few parameters to a report.
    -----------------------------------------------
    BEGIN
    OPEN MNTH_HEAD;
    FETCH MNTH_HEAD INTO H_PRNO,H_PRSDATE,H_PREDATE,H_PRNAME;
    CLOSE MNTH_HEAD;
    PARAMETER_LIST_ID:=CREATE_PARAMETER_LIST('PR_DATA' );
    ADD_PARAMETER(PARAMETER_LIST_ID,'PROJECTNUMBER',TE XT_PARAMETER,H_PRNO);
    ADD_PARAMETER(PARAMETER_LIST_ID,'STARTDATE',TEXT_P ARAMETER,H_PRSDATE);
    ADD_PARAMETER(PARAMETER_LIST_ID,'ENDDATE',TEXT_PAR AMETER,H_PREDATE);
    ADD_PARAMETER(PARAMETER_LIST_ID,'PROJECTNAME',TEXT _PARAMETER,H_PRNAME);
    RUN_PRODUCT(REPORTS,'FOUR',SYNCHRONOUS,RUNTIME,FIL ESYSTEM,PARAMETER_LIST_ID,NULL);
    DESTROY_PARAMETER_LIST(PARAMETER_LIST_ID);
    END;
    -------------------------------------
    Now please tell me how I can refer these passed parameters values from the report? Any help will be highly appreciated.

    Thanks in advance
    raj

  2. #2
    Join Date
    Feb 2004
    Posts
    108
    Have these parameters in your report. Use them in your report queries.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •