Trying to run an Excel file or a website from a FEX

[H1004]

I have a simple FEX that lists out all the reports name. 3 of the reports will run another FEX when clicked; however,
the last one is either getting an Excel file in the server or link to a website somewhere out in the Internet.
But I can't seem to get it to work because I got an error message saying it can't find the FOCEXEC when it's
not a FOCEXEC that it is trying to run. Please help!\
Here is my code:

TABLE FILE tablename
PRINT
field1 NOPRINT
HEADING
"REPORTS YOU HAVE ACCESS TO:"
" "
" "
"Summary Activity and Category Report"
"Detail Activity and Category Report"
"Transaction Report"
"Continuous Updated Activity and Category Report"
WHERE RECORDLIMIT EQ 1
ON TABLE SET BYDISPLAY OFF
ON TABLE NOTOTAL
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR=BLACK,
BACKCOLOR=NONE,
STYLE=NORMAL,
$
TYPE=HEADING,
LINE=4,
OBJECT=TEXT,
ITEM=1,
FOCEXEC=fex1,
$
TYPE=HEADING,
LINE=5,
OBJECT=TEXT,
ITEM=1,
FOCEXEC=fex2,
$
TYPE=HEADING,
LINE=6,
OBJECT=TEXT,
ITEM=1,
FOCEXEC=fex3,
$
TYPE=HEADING,
LINE=7,
OBJECT=TEXT,
ITEM=1,
URL=url[

http://www.yahoo.com

],
$
ENDSTYLE
END

 

[WFGuru]

Does your code have

TYPE=HEADING,
LINE=7,
OBJECT=TEXT,
ITEM=1,
URL=url[

http://www.yahoo.com

],
$

OR

TYPE=HEADING,
LINE=7,
OBJECT=TEXT,
ITEM=1,
URL=http://www.yahoo.com,
$

The later would be correct

 

[H1004]

I tried the later piece of code, and I got
error msg:

FOC227: THE FOCEXEC PROCEDURE CANNOT BE FOUND: TEMP0037FOCEXEC*

 

[WFGuru]

What release are you running? It works for me. The alternative is to put the link in a defined field and put that in the heading like this.

DEFINE FILE CAR
YAHOO/A100 =' <a href="

http://www.yahoo.com">

yahoo </a>';
END
TABLE FILE CAR
"</5"
"<YAHOO

 

[H1004]

The reason it didn't work for me the first time was because I didn't run it in the MRE, but through Desktop Power Reporter. However, I have another question, which has to do with formatting. I tried to make the hyperlink to have the white color, but instead it default to blue. Is there a way I can change the color. Here is my code:

DEFINE FILE CAR
MOD/A100= ' <a href="/ibi_html/Info.doc"> Analysis Report1 </a>';
MOD2/A100= ' <a href="/ibi_html/Info.doc">Analysis Report2 </a>';
END
TABLE FILE CAR
PRINT
CAR NOPRINT
HEADING
"Analysis Report for Period &MONTH of &YEAR"
" "
" "
"<MOD"
"<MOD2"
ON TABLE SET PAGE-NUM OFF
ON TABLE SET BYDISPLAY OFF
ON TABLE NOTOTAL
ON TABLE SET STYLE *
UNITS=IN,
PAGESIZE='Letter',
LEFTMARGIN=0.250000,
RIGHTMARGIN=0.250000,
TOPMARGIN=0.250000,
BOTTOMMARGIN=0.250000,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR=BLACK,
BACKCOLOR=NONE,
STYLE=NORMAL,
BOTTOMGAP=0.027778,
$
TYPE=HEADING,
BACKCOLOR=RGB(64 128 128),
$
TYPE=HEADING,
LINE=1,
OBJECT=TEXT,
ITEM=1,
SIZE=12,
COLOR=RGB(255 255 128),
STYLE=BOLD+UNDERLINE,
$
TYPE=HEADING,
LINE=4,
OBJECT=FIELD,
ITEM=1,
SIZE=12,
COLOR=WHITE,
STYLE=BOLD,
$
TYPE=HEADING,
LINE=5,
OBJECT=FIELD,
ITEM=1,
SIZE=12,
COLOR=WHITE,
STYLE=BOLD,
$
END

Thank you,