Hi,

Running on MS server 2003 with WF reporting server 7.6.4

We have a WF report being held in Excel with a hyperlink to a file that needs to be fetched from a catalouge.

This works fine as a HTML report but not as an EXL2K or PDF. We get a HTTP status 404 from Apache Tomcat/5.5.26, any one knows what is wrong?

Thanks
Robert

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

When you hover your cursor on the hyperlink, do you see a proper, complete URL pointing to your file?

Depending on how the URL is built, you may need to use the SET FOCEXURL command to set up the URL of the WebFOCUS server. e.g.:

SET FOCEXURL=http://localhost:8080/ibi_apps/WFServlet

I did hover over the cell and yes it show /ibi_apps/WFServlet but that is causing the problem as the file is located in another place and we are not runninng a drill down so the FOCEXURL is not helping.

When we ran it as a HTML we set the BASEURL to the server and it worked. So how to get this address to Excel?

Please post the code that shows how you're constructing the URL. Please put the code between code tags by clicking on < / > at the top of the Post A Reply window.

Hi,

The code below, SET_DIR1 is the catalouge where the file is stored. All the link has to do is to point to the file and allow the person to fetch it from the server to his/her laptop. The same code works when running as a HTML.

-SET &URL= 'http://' || &ADR_TST || '/';
SET BASEURL =&URL

DEFINE FILE IMPORT_RES
AIMP/A8=EDIT(HCNVRT(IMPORT_TIMESTAMP, '(H17)', 17, 'A20'),'99999999');
AMONTH/A6=EDIT(AIMP,'999999');
IIMP/I8 = EDIT(AIMP);
SET_DIR1/A100=IF ECODE EQ 5 OR 6 THEN  '&SET_WAITDIR1' ELSE
                          IF ECODE EQ 32 OR 73 THEN  '&SET_EXDIR1' ELSE
                          IF ECODE EQ 3 THEN  ' ' ELSE 
                          '&SET_IMPDIR1';
ATT/A500=SET_DIR1||'/'||AMONTH||'/'||AIMP||'/'||ZIP_FILE_NAME;
LINKTXT/A15=IF ECODE NE 3 THEN 'Link to file' ELSE ' ';
END
TABLE FILE IMPORT_RES
PRINT 
     LINKTXT AS 'File'
   ATT NOPRINT
HEADING
"Import Status Report<+0>Userid: &DISP_USER <+0>Date: &YYMD"
"From:<+0>&SEL_FROM To &SEL_TO"
" "
WHERE IIMP FROM &SEL_FROM TO &SEL_TO;
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
     UNITS=IN,     SQUEEZE=ON,     ORIENTATION=PORTRAIT,     PAGECOLOR='WHITE',$
TYPE=REPORT,      FONT='ARIAL',     SIZE=9,$
TYPE=DATA,     COLUMN=LINKTXT,   URL=(ATT),WHEN=ECODE NE 3,$
TYPE=TITLE,     SIZE=8,     BACKCOLOR='SILVER',     STYLE=BOLD,$
TYPE=TABHEADING, SIZE=12,     STYLE=BOLD,$
TYPE=TABFOOTING,  SIZE=12,     STYLE=BOLD,$
TYPE=HEADING,     BORDER-TOP=LIGHT,     BORDER-BOTTOM=MEDIUM,
     BORDER-LEFT=LIGHT,     BORDER-RIGHT=LIGHT,     SIZE=8,     STYLE=BOLD,$
TYPE=SUBHEAD,     SIZE=10,     STYLE=BOLD,$
TYPE=SUBFOOT,     SIZE=10,     STYLE=BOLD,$
TYPE=SUBTOTAL,     BACKCOLOR=RGB(210 210 210),$
TYPE=ACROSSVALUE,     SIZE=9,$
TYPE=ACROSSTITLE,     STYLE=BOLD,$
TYPE=GRANDTOTAL,     BACKCOLOR=RGB(210 210 210),     STYLE=BOLD,$
ENDSTYLE
END
-RUN

Robert,
When you do a URL drilldown, you have two choices:
first one is to construct the url in a relative way, ie without the protocol and server part. This should result in correct url's as long as you stay within the browser.
second one is to construct the url in an absolute way, ie with the protocol and server part. This will always result in a correct url, also when you save the file to disk and open it later.
Thing to note here is that is you use the url drilldown, the baseurl and focexurl are not being used to construct the ultimate url, the value you specify yourself in the fex is what is being used.
So to be on the safe side, I'd advise to always construct complete and absolute url addresses in any url-drilldown.

Thanks GamP for that.

I have changed the whole thing to run a focexec which has a js that tries to access the file and it works but it does not open a new window. It seems that going from the plug-in Excel (in the browser window) there is no way of opening a new window and retaining the Excel plug-in because whatever I try to do it keeps loading into the same window(_self).

By the way, on excel 2007 it works diffrently then excel 2003.

This message has been edited. Last edited by: Robert Teo,