Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Hyperlink gives 404.

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED] Hyperlink gives 404.
 Login/Join
 
Silver Member
posted
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,


A message from the darks side, there is!
 
Posts: 39 | Registered: August 28, 2007Report This Post
Expert
posted Hide Post
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


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Silver Member
posted Hide Post
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?


A message from the darks side, there is!
 
Posts: 39 | Registered: August 28, 2007Report This Post
Expert
posted Hide Post
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.


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
 
Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Report This Post
Silver Member
posted Hide Post
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


A message from the darks side, there is!
 
Posts: 39 | Registered: August 28, 2007Report This Post
Virtuoso
posted Hide Post
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.


GamP

- Using AS 8.2.01 on Windows 10 - IE11.
in Focus since 1988
 
Posts: 1961 | Location: Netherlands | Registered: September 25, 2007Report This Post
Silver Member
posted Hide Post
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,


A message from the darks side, there is!
 
Posts: 39 | Registered: August 28, 2007Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Hyperlink gives 404.

Copyright © 1996-2020 Information Builders