| who dares to give the solution [message #86823] |
Sun, 07 November 2004 07:39  |
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
|
|
|
|
| Re: who dares to give the solution [message #86824 is a reply to message #86823] |
Sun, 07 November 2004 23:31  |
Himanshu
Messages: 457
Registered: December 2001
|
Senior Member |
|
|
Hi,
Farhan, this is due to the fact that RUN_PRODUCT does not use MTS(Multi threaded server), so if you request multiple reports,the call will be submitted to report engine but it will be displayed only after previous report is closed.
Modify all you programs to run report using Run_report_object.
You will have to install MULTI_TIER SERVER edition of Oracle Reports & configure the report server.
HTH
Regards
Himanshu
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
