[CLOSED] open execl with office issue.

August 27, 2010, 11:17 PM

I set the XLS "file Types" -- "browse in same window"(selected)

when I run the fex, click the open excel , the execl open in the IE. the report have the link , it's work.

I set the XLS "file Types" -- "browse in same window"(not select)

when I run the fex, click the open excel , the reprot open with Office , everything is work except the link ...

I use the code:

FOCEXEC=app/outputexcel.fex(\
...........
...........
...........
...........),
TARGET = _blank,
ALT              = 'Output to Excel,
$

Why the link is not work ?

This message has been edited. Last edited by: Kerry,

August 30, 2010, 10:44 AM

Francis Mariani

You must specify the URL of the WebFOCUS program. Here is an example:

-SET &ECHO = 'ALL';

SET FOCEXURL = 'http://localhost:8080/ibi_apps/WFServlet?'
-RUN

-DEFAULT &COUNTRY = 'FOC_NONE';

-SET &RNDM = EDIT(HHMMSS('A8'),'99$99$99');

TABLE FILE CAR
SUM SALES
BY COUNTRY
BY CAR
BY MODEL

WHERE COUNTRY EQ '&COUNTRY';

HEADING
"CAR REPORT"
" "

ON TABLE PCHOLD FORMAT EXL2K

ON TABLE SET STYLE *
TYPE=HEADING, LINE=1, ITEM=1, FOCEXEC=EXCEL3 (COUNTRY='FOC_NONE' RNDM='&RNDM'), $
TYPE=DATA, COLUMN=COUNTRY, FOCEXEC=EXCEL3 (COUNTRY=COUNTRY RNDM='&RNDM'), $
TYPE=TITLE, STYLE=BOLD, $
ENDSTYLE
END
-RUN

Replace "localhost:8080" with the server name of your environment.

Documentation:

quote:

The FOCEXURL parameter runs and executes drill downs remotely. The drill down program can be on your local machine or on a remote machine.

The syntax is:

SET FOCEXURL = path

where:

path - is the location of the WebFOCUS Servlet, CGI, or ISAPI. The default path for Servlet is /ibi_apps/WFServlet. The default for CGI is /cgi-bin/ibi_cgi/ibiweb.exe and for ISAPI is /cgi-bin/ibi_cgi/webapi.dll.