Focal Point
Webfocus 8 Excel comes up in background
January 08, 2015, 01:11 PM
secretWebfocus 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
Dougcan't you just use the ALT+TAB" key Windows sequence to get to it?
January 08, 2015, 02:56 PM
Francis MarianiThere 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
Wep5622What 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
DougYep, 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
Dougquote:
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
Wep5622That'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 :