Focal Point
COMPUND EXL2K DOESN'T OPEN IN WIN2000

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

August 28, 2007, 12:44 PM
Alek_
COMPUND EXL2K DOESN'T OPEN IN WIN2000
Hello, I created a compound report with output to EXL2K. It opens fine in Windows XP but doesn't in Windows 2000, it gives some XML code instead of a spreadsheet.
Thanks in advance


WF 8.0.6
Windows Server 2003
August 28, 2007, 12:52 PM
Leah
I believe that what gets passed is a form of xml, so I'd venture a guess you have to change a windows setting or IE setting somewhere.

My customers are living with error messages because they've gone to office 2007. Fortunately the file still opens.


Leah
August 28, 2007, 01:07 PM
Alek_
Thanks Leah, I tried to modify Folder Options>File Types>XLS, but it didn't help. Maybe Excel on Windows 2000 doesn't read XML. Here is what comes up:
MIME-Version: 1.0
X-Document-Type: Workbook
Content-Type: multipart/related; boundary="====Boundary===="

--====Boundary====
Content-Location: file:///C:/HOLD.XHT
Content-Transfer-Encoding: 8bit
Content-Type: text/html; charset="us-ascii"


="urn:schemas-microsoft-comRed FacefficeRed Faceffice"
xmlns:x="urn:schemas-microsoft-comRed Faceffice:excel"
xmlns="-//W3C//DTD HTML 4.0//EN">








Sheet1




....


WF 8.0.6
Windows Server 2003
August 28, 2007, 01:27 PM
Francis Mariani
Don't you need MS Office 2003 or later for these compound reports? Perhaps the Windows 2000 PC does not have Office 2003...


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
August 28, 2007, 01:28 PM
Leah
I wonder if you installed the microsoft fix for file extentions they put out to help us 2003 folks open 2007 files would help.
You might find some information here.
http://office.microsoft.com/en-us/products/HA101686761033.aspx


Leah
August 28, 2007, 03:45 PM
Alek_
I think that's the problem, need an office 2003.
Thanks everybody for your help!


WF 8.0.6
Windows Server 2003
August 29, 2007, 09:27 AM
jgelona
Alek_, are you using Excel 2002 or higher? I believe that is a documented requirement.

The reason I ask is the first one of these I did, my PC OS with W2K. I had to upgrade to Office 2003 to get the output.


In FOCUS since 1985. Prod WF 8.0.08 (z90/Suse Linux) DB (Oracle 11g), Self Serv, Report Caster, WebServer Intel/Linux.