Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Hi I call some Oracle reports fr

Status
Not open for further replies.

statcan

Programmer
Mar 27, 2003
12
CA
Hi

I call some Oracle reports from my Oracle Forms 6 application using Run_Report_Object built-in. This opens a window that is the Reports Background engine while running the report. My problem is that when I close the report preview window, this background engine window does not go away.

How can I hide this engine window programmatically?

Thanks for your replies in advance
 
1. To close it right after report, pass ORACLE_SHUTDOWN=YES via Other Reports Parameters
2. To close it on closing form, add the following code to KEY-EXIT trigger:

DECLARE

iRC NUMBER;
rbTitle varchar2(50) := 'Reports Background Engine';
begin
iRC := win_api_session.findAppwindow(rbTitle,
'rwrbe60.exe',
'WINDOW',
WIN_API.WINCLASS_REPORTSSERVER_V6,
FALSE);

if iRC> 0 THEN
if win_api_session.Find3rdPartyApp (rbTitle,
'rwrbe60.exe',
'WINDOW',
TRUE,
WIN_API.WINCLASS_REPORTSSERVER_V6,
FALSE) THEN

win_api_shell.sendkeys(iRC, '%{F4}', true);

end if;
end if;;
end;


Note, that window title (rbTitle) may depend on NLS_LANG environment variable.

Regards, Dima
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top