Focal Point
Webfocus 8 Excel comes up in background

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/8977012476

January 08, 2015, 01:11 PM
secret
Webfocus 8 Excel comes up in background
We are converting a Webfocus application from webfocus 7 to webfocus 8. I luanch a report from an HTML form. The Excel report comes up in the background. I have to logoff to get the excel message to open the report to come to the foreground.
January 08, 2015, 01:36 PM
Doug
can't you just use the ALT+TAB" key Windows sequence to get to it?
January 08, 2015, 02:56 PM
Francis Mariani
There definitely is some odd behaviour with WF 8, IE 9, and Excel. If you already have a WebFOCUS generated Excel spreadsheet open and windows is focused on an IE window where you run another report in Excel format - there is no indication that Excel needs your feedback - you know, that annoying message about trying to open another file names wfservelet.xslx... And I keep getting prompted for Windows authentication before being able to open the file in Excel.


Francis


Give me code, or give me retirement. In FOCUS since 1991

Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
January 09, 2015, 05:38 AM
Wep5622
What I find the most curious about those authentication prompts is that it's sufficient to Cancel the prompt instead of filling in your credentials. The big benefit of cancelling is that you only need to do that once, while when providing your credentials you get asked to authenticate another 2 times (for a total of 3).

And indeed, it is quite annoying that Excel doesn't take focus. This issue regularly causes users to call us that their Excel reports aren't working when they are - they just didn't notice.


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :
January 09, 2015, 09:43 AM
Doug
Yep, there's definately some odd behavior with WF 8, IE 9, and Excel, and even moreso with IE11. However, as far as i konw, WF Is not yet certified with IE11. Compatibility mode helps in most cases.

Have you consider useing FORMAT XLSX?




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
January 09, 2015, 09:45 AM
Doug
quote:
while when providing your credentials you get asked to authenticate another 2 times (for a total of 3).
Is that with SSO as well? We only get prompted once after we're into MRE...
January 09, 2015, 09:53 AM
Wep5622
That's with self-service reporting and IWA ("Integrated Windows Authentication" through the IIS web server product).


WebFOCUS 8.1.03, Windows 7-64/2008-64, IBM DB2/400, Oracle 11g & RDB, MS SQL-Server 2005, SAP, PostgreSQL 11, Output: HTML, PDF, Excel 2010
: Member of User Group Benelux :