Home » Developer & Programmer » Reports & Discoverer » need help on urgent basis
need help on urgent basis [message #90139] Sun, 07 November 2004 07:41
fanni
Messages: 96
Registered: March 2004
Member
i am calling the reports by using this code

----------------

OCEDURE Call_module ( p_cm_name Varchar2) IS
        v_cm_type varchar2(30);
        v_cm_module varchar2(130);
        repid REPORT_OBJECT;
        v_rep  VARCHAR2(100);
        rep_status varchar2(20);
        pl_id ParamList; 

 
BEGIN
        SELECT FUNCTION_TYPE, FUNCTION_MODULE
        INTO v_cm_type, v_cm_module
        FROM CMS_FUNCTIONS
        WHERE FUNCTION_NAME = p_cm_name;
       
 
        IF v_cm_type = 'FORMS' THEN
         CALL_Form( v_cm_module);--, NO_HIDE, dO_REPLACE );
        ELSE
 
      pl_id := Create_Parameter_List('tmpdata');
     Add_Parameter(pl_id, 'PARAMFORM', TEXT_PARAMETER, 'NO');
     Add_Parameter(pl_id, 'P_LOGIN_SEASON', TEXT_PARAMETER, :GLOBAL.P_LOGIN_SEASON);
         Run_Product(REPORTS, v_cm_module, ASYNCHRONOUS, RUNTIME,FILESYSTEM,pl_id,null);
         Destroy_Parameter_List( pl_id );
        END IF;
       
       
 
EXCEPTION
        WHEN OTHERS THEN
        MESSAGE('When Others error...'||sqlerrm);
END;
 

----------------

i have made a function and uses this function for caling the reports from the menu. but there is a problem that it opens only one report at one time if one report is opened and i click the othr report it does not open the second report untill the first report is closed.

i need it on urgent basis

regards

farhan ashraf

 

 
Previous Topic: dba
Next Topic: Reports 6i
Goto Forum:
  


Current Time: Mon Nov 25 16:58:39 CST 2024