I am getting following error, when i open the report in office 2007, the report is a drill down to 3 levels. 1st level message
"File you are trying to open , 'WFServlet.xls', is in a different format than specified by the file extension"
when i say 'yes' on the poup, the report opens , but when i click on the drill down to next level in the report in the to 2nd level i get the poup like :
"A document with the name 'WFServlet' is already open. You can not open 2 documents with the same name even the documents are in the different folders" In the 3rd level: "Unexpected error" i cont get the data for the 3rd level.
Did any one ahve the same kind of problem ?
I am having the Webfocus 7.6.4 version . Help is appreciate.
Thanks RekhaThis message has been edited. Last edited by: Kerry,
WebFocus 7.6.4 windows XP MS SQL 2000/2005
November 13, 2008, 11:26 AM
Michael Meagher
Those are both common messages when you output to Excel 2007. The first may be because WebFOCUS is not sending the 2007 flavor of XLS. The second is because WebFOCUS creates files with the same name as you drill down.
November 13, 2008, 01:56 PM
Rekha
That is OK to get messages, when you drill down to each level, but in the 3rd level drill down, i am getting the "Un expected error " and not able to open the spreadsheet, and cont get report for 3rd level. What should i do ?
WebFocus 7.6.4 windows XP MS SQL 2000/2005
November 13, 2008, 02:11 PM
Francis Mariani
1) Ensure you have the command SET FOCEXURL = path to enable drilldowns for PDF and Excel 2) Check if the drilldowns work in HTML.
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
November 13, 2008, 04:07 PM
Rekha
yes, it all works in AHTML and the office 2003, only having problem in office 2007. There is no popups when i open in excel 2003
WebFocus 7.6.4 windows XP MS SQL 2000/2005
June 22, 2009, 10:51 AM
Pku
Rekha,
I wonder that have you ever solved your problem yet? I have encountered the same situation where I can not drill down in the third level in Excel 2007 and the popup message is "An unexpected error has occurred".
Thanks,
Thanks, Pku
Focus, WebFocus 8201 on Windows
June 23, 2009, 04:42 AM
GamP
I have no problem whatsoever drilling down in excel 2007. My drilldowns go to a maximum of 7 levels deep in one case and even 9 levels in another. All work without any error message, not even the messages mentioned earlier in this post. The server release I have this working on is 765 in production and 769 in development. Both show the same behaviour: correct in all cases. I do have my focexurl set and I have the application folder in the servers app path.
