| Reports 10g [message #479926] |
Wed, 20 October 2010 04:15  |
iamdbest_joy
Messages: 6
Registered: August 2010
|
Junior Member |
|
|
I am running a report which is called for a set of employees picked up in the cursor. For each employee the report is run in a different window. However, the report runs fine and the output gets saved in the local machine but the window doesnot get closed automatically.
Please suggest how to close the reports window automatically without manual intervention?
Thanks in advance.
|
|
|
|
|
|
| Re: Reports 10g [message #480165 is a reply to message #479929] |
Thu, 21 October 2010 09:28  |
iamdbest_joy
Messages: 6
Registered: August 2010
|
Junior Member |
|
|
From the menu of my application I am using cursor to pick up the employees.
declare
cursor c1 is
select candnumber from mnt_cand_master
order by 1;
begin
FOR C1_REC IN C1
LOOP
run_offer_letter_bulk('test_rep',C1_REC.CANDNUMBER);
END LOOP;
end;
PROCEDURE RUN_OFFER_LETTER_BULK (report_name IN VARCHAR2, R_candno in number) IS
l_name varchar2(20);
BEGIN
l_name := to_char(R_candno);
web.show_document('/reports/rwservlet?rep_server5&report='||report_name||'.rdf&desformat=pdf&destype=File&p_cand_no=' ||R_candno||'&desname=C:\OFFER_LETTER\'||l_name||'.pdf&today='||to_char(sysdate,'DD-MON-RR')||'&mode=default&P_SYS_GR OUP_ID='||:GLOBAL.sys_grp_id||'&P_SYS_USR_LVL='||:GLOBAL.sys_usr_lvl||'¶mform=NO','_blank');
END;
This procedure opens the report for each employee in a different window. I need to close each window once the report output is generated and says "Successfully Run".
Please guide me.
[Updated on: Thu, 21 October 2010 09:40] Report message to a moderator |
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
