Focal Point
[SOLVED] EXL07 issue

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

August 01, 2011, 06:13 PM
ReddyP
[SOLVED] EXL07 issue
We are trying to run a report using EXL07 format.
There are two issues we are facing.
1. Report keeps running.
I tried even with the car file. Report keeps running.
2. I tried using SQL passthru for one of our existing reports and that helped us
to be able to run the report.
But, when we get the output, we are being prompted with this error
"Do you want to save this file. or find a program online to open it?"
I tried all the redirect settings as per the documentation, cleared cache and
still it does not work.

Any ideas?

Thank you.

This message has been edited. Last edited by: Kerry,
August 01, 2011, 06:36 PM
Waz
Hi ReddyP, welcome to the forum.



Are you able to post your code ?

the one with the car file would be great.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

August 01, 2011, 07:03 PM
ReddyP
Thank you Waz.
This is what I used for car file.
TABLE FILE CAR
PRINT *
ON TABLE PCHOLD FORMAT EXL07
END


7.7.01,windows2008 R2
August 01, 2011, 07:30 PM
Waz
What happens if you change the code to HOLD instead of PCHOLD ?


Also, using PRINT * from a multisegment file will not get all records in some segements.


Waz...

Prod:WebFOCUS 7.6.10/8.1.04Upgrade:WebFOCUS 8.2.07OS:LinuxOutputs:HTML, PDF, Excel, PPT
In Focus since 1984
Pity the lost knowledge of an old programmer!

August 02, 2011, 04:25 AM
OPALTOSH
The message you are seeing indicates to me that the report has finished running and the output file is being downloaded but the PC you are running it from does not have Excel 07 available to open the file with. This often happens when you test run a report directly on a server, as servers do not tend to have MS Office products installed on them.
August 02, 2011, 10:11 AM
paulI
I posted something similar with performance issues. Please check post titled '[EXPLAINED] EXL2K vs EXL07 performance'. I fould the responses very usefull. We ended up running our reports as EXL2K after a test on a simple print ran for 3 seconds in EXL2K mode and 2.5 hours in EXL07. We are on EF 7701.


Prod: WF 7.7.05, BID, MRE, 7.7.06M Server, Windows 2008, RedHat, Oracle 11gR1, MS Office 2010
Test: I wish we had one!
August 17, 2011, 08:03 PM
ReddyP
I submitted a case for this and the response I got was that there were lot of fixes that went on for 7.7.1 and 7.7.2
I tested this on 773 and it works fine.
Thanks you all for your help.


7.7.01,windows2008 R2
August 18, 2011, 12:52 PM
jammer
On my test server I have version 7.703
I also see that EXL07 takes forever to open.

My report is big - 5000 rows and 190 columns

EXL2K - about 20 second
EXL07 - about 4 MINUTES

I'm sticking to EXL2K for now - and will be calling IBI Support


Webfocus 7.6.4
Windows 2003 Server, SQL Server 2005
Excel, HTML , JavaScript ,and PDF.
Reportcaster, BID, Tomcat