OraFAQ Forum: Forms » 11g OLE2 Excel printing behind parameter form.

Home » Developer & Programmer » Forms » 11g OLE2 Excel printing behind parameter form. (11g R2 Forms)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

11g OLE2 Excel printing behind parameter form. [message #549904]

Wed, 04 April 2012 10:01

bigant
Messages: 3
Registered: April 2012
Location: london

Junior Member

When I click on excel report button on the parameter form, the excel runs behind the form instead of in running in fron of it thereby making it partially invinsible. I am having to minimise the form to have a clear view. This is not the case with Forms 10g.
Is there an extra code on the OLE2 to send the form to the backgroud so that the excel output can take over the screen.
Any help would be appreciated please.
Thanks, Ant.

Report message to a moderator

Re: 11g OLE2 Excel printing behind parameter form. [message #549912 is a reply to message #549904]

Wed, 04 April 2012 11:04

owais_baba
Messages: 289
Registered: March 2008
Location: MUSCAT

Senior Member

can u upload screen shots

regards
baba

Report message to a moderator

Re: 11g OLE2 Excel printing behind parameter form. [message #550000 is a reply to message #549912]

Thu, 05 April 2012 03:54

bigant
Messages: 3
Registered: April 2012
Location: london

Junior Member

Hi Baba, I have attached a screen shot of this image. Ideally I would like the excel sheet to cover the form when invoked by the OLE2 function instaed of hing behind the form. This is usually the case with 10g form. I appreciate your help, thanks

/forum/fa/10032/0/

[EDITED by LF: inserted image into message body]

Attachment: Untitled.gif
(Size: 66.25KB, Downloaded 1737 times)

[Updated on: Thu, 05 April 2012 12:14] by Moderator

Report message to a moderator

Re: 11g OLE2 Excel printing behind parameter form. [message #550055 is a reply to message #550000]

Thu, 05 April 2012 10:45

owais_baba
Messages: 289
Registered: March 2008
Location: MUSCAT

Senior Member

Friend picture which u have uploaded i am not able to see might be some technical problem or uploading anyway. I dont think i could provide you any relevant answere hope someone could provide some relevant answers from this forum but these link and fmb file might could provide you some helps through this fmb file excel runs on front of form not behind might be could help you

http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/11g/r2/prod/bidw/olap11g_excel/olap_excel.htm

http://docs.oracle.com/cd/E15523_01/bi.1111/b32122/orbr_howto007.htm

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

regards
baba

Attachment: CALL_EXCEL_REPORT2.fmb
(Size: 48.00KB, Downloaded 1366 times)

[Updated on: Thu, 05 April 2012 10:47]

Report message to a moderator

Re: 11g OLE2 Excel printing behind parameter form. [message #550061 is a reply to message #550055]

Thu, 05 April 2012 12:16

Littlefoot
Messages: 21823
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

@bigant, next time you upload an image, it would be better if you take a shot of the relevant part of your screen. Now you attached huge picture which is mostly empty, and important stuff is just too tiny to see anything. For me, at least.

Report message to a moderator

Re: 11g OLE2 Excel printing behind parameter form. [message #550071 is a reply to message #550061]

Thu, 05 April 2012 14:31

Sticker Printing
Messages: 7
Registered: March 2012
Location: USA

Junior Member

Web service error response (code/message etc) would you store it in a database? or would you keep the error response in a method.By the time I'm done with this, there will be hundreds of error response, maybe in the future, thousands?

Report message to a moderator

Re: 11g OLE2 Excel printing behind parameter form. [message #550662 is a reply to message #550071]

Wed, 11 April 2012 06:08

bigant
Messages: 3
Registered: April 2012
Location: london

Junior Member

Thanks for all your imput guys.
Today, i was able to resolve the problem. I think the problem is Window 7 issues.
If anyone has same problem, this line of code should do the trick.

CLIENT_OLE2.SET_PROPERTY(application, 'WINDOWSTATE',-4140);

Report message to a moderator

Previous Topic:	open excel application from forms
Next Topic:	Bean not found when form is loaded

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 03 04:12:18 CST 2025