Focal Point
[CLOSED] open execl with office issue.

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

August 27, 2010, 11:17 PM
Yangyang
[CLOSED] open execl with office issue.
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,


WebFOCUS 7.6.8
WebFOCUS 7.6.10
BI
FLEX
.NET
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.



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