Focal Point
Error Opening Excel Template

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

March 04, 2008, 10:46 AM
linus
Error Opening Excel Template
I have read three pages of posts on working with Excel Templates, I've read documentation from an IBUG meeting, I have instructions from a friend and I still can't get it to work.
I've created my .mht file which contains two worksheets, worksheet one contains a space in column A, worksheet two contains a space in column A and columns 16 - 29 are formated to display my column headings vertically. I"ve ftp'd the file to the reporting server. I've file def'd the template and the output file.

APP FI COMPXLS DISK webfocus/compxls.mht
APP FI COMPXLS1 DISK compxls1.mht
-RUN

the directory 'webfocus' is in my app path.

I am creating a single report. I keep getting the following error:

(FOC3289) EXL2K TEMPLATE FILE: Error opening file
(FOC009) INCOMPLETE REQUEST STATEMENT
BYPASSING TO END OF COMMAND

What am I doing wrong?

Thanks,

Linus


WF 7.7.05
HP-UX - Reporting Server, Windows 2008 - Client, MSSQL 2008, FOCUS Databases, Flat Files
HTML, Excel, PDF
March 04, 2008, 11:17 AM
linus
I'm replying to my own post -- my problem is UNIX security -- I changed the security set on the template in UNIX and my program works fine.


WF 7.7.05
HP-UX - Reporting Server, Windows 2008 - Client, MSSQL 2008, FOCUS Databases, Flat Files
HTML, Excel, PDF
March 05, 2008, 09:48 AM
PBrightwell
Glad to know you got it working Linda, good luck in the ice and snow


Pat
WF 7.6.8, AIX, AS400, NT
AS400 FOCUS, AIX FOCUS,
Oracle, DB2, JDE, Lotus Notes