Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only. Moving forward, myibi is our community platform to learn, share, and collaborate. We have the same Focal Point forum categories in myibi, so you can continue to have all new conversations there. If you need access to myibi, contact us at myibi@ibi.com and provide your corporate email address, company, and name.


Connect to myibi
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] EXL07 issue

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] EXL07 issue
 Login/Join
 
Gold member
posted
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,
 
Posts: 65 | Registered: July 28, 2011Report This Post
Expert
posted Hide Post
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!

 
Posts: 6349 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Gold member
posted Hide Post
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
 
Posts: 65 | Registered: July 28, 2011Report This Post
Expert
posted Hide Post
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!

 
Posts: 6349 | Location: 33°49'23.0"S, 151°11'41.0"E | Registered: October 31, 2006Report This Post
Platinum Member
posted Hide Post
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.
 
Posts: 140 | Location: Adelaide South Australia | Registered: October 27, 2006Report This Post
Gold member
posted Hide Post
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!
 
Posts: 75 | Location: Wichita, KS | Registered: February 19, 2008Report This Post
Gold member
posted Hide Post
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
 
Posts: 65 | Registered: July 28, 2011Report This Post
Gold member
posted Hide Post
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
 
Posts: 79 | Registered: May 02, 2006Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] EXL07 issue

Copyright © 1996-2020 Information Builders