Focal Point Banner
Community Center Education Summit Technical Support User Groups
Let's Get Social!

Facebook Twitter LinkedIn YouTube
Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Hyperlink as Excel Field Value
Go
New
Search
Notify
Tools
Reply
  
[SOLVED] Hyperlink as Excel Field Value
 Login/Join
 
Platinum Member
posted
I can get a hyperlink to appear as a field value in EXL2K output, but it appears only as text.

Is there a way to make this a working (clickable) hyperlink?

DEFINE FILE CAR
BLANKER/A500 WITH COUNTRY= '';
URL/A255 = 'http://www.google.com';
END

TABLE FILE SOC_ARSCHEMA
PRINT
BLANKER AS 'BLANKER'
URL AS 'URL'

WHERE RECORDLIMIT EQ 1

ON TABLE PCHOLD FORMAT EXL2K
END
-EXIT

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


Production - 7.6.4
Sandbox - 7.6.4
 
Posts: 241 | Location: Bethesda, MD | Registered: August 14, 2007Reply With QuoteReport This Post
Platinum Member
posted Hide Post
DEFINE FILE CAR
BLANKER/A500 WITH COUNTRY= '';
URL/A255 = 'Google';
END
TABLE FILE CAR
PRINT
CAR AS 'BLANKER'
URL AS 'URL'
WHERE RECORDLIMIT EQ 1
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=2, URL='http://www.google.com',$
ENDSTYLE
END


WF 8.2.06
Win10 / IE11
AHTML EXL2K PDF
 
Posts: 189 | Registered: October 19, 2010Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Interesting. I would not have thought to put the URL in the stylesheet.


Production - 7.6.4
Sandbox - 7.6.4
 
Posts: 241 | Location: Bethesda, MD | Registered: August 14, 2007Reply With QuoteReport This Post
Guru
posted Hide Post
I couldn't make it work properly in my application, what is wrong with it?

DEFINE FILE CAR
BLANKER/A500 WITH COUNTRY= '';
URLink/A255 = IF COUNTRY EQ 'ENGLAND' THEN 'http://www.google.gb' ELSE 'http://www.google.com';
END
TABLE FILE CAR
PRINT
CAR AS 'BLANKER'
COUNTRY AS 'Local Google'
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=2, URL=URLink,$
ENDSTYLE
END

  


Developer Studio 7.6.11
AS400 - V5R4
HTML,PDF,XLS
 
Posts: 305 | Location: Winnipeg,MB | Registered: May 12, 2008Reply With QuoteReport This Post
Expert
posted Hide Post
You can't use a "field" in a URL:

  
DEFINE FILE CAR
BLANKER/A500 WITH COUNTRY= '';
END
TABLE FILE CAR
PRINT
CAR AS 'BLANKER'
COUNTRY AS 'Local Google'
ON TABLE PCHOLD FORMAT EXL2K
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=N2, URL='http://www.google.gb',  WHEN= COUNTRY EQ 'ENGLAND',$
TYPE=DATA, COLUMN=N2, URL='http://www.google.com', WHEN= COUNTRY NE 'ENGLAND',$
ENDSTYLE
END
-EXIT


Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe
 
Posts: 1973 | Location: Centennial, CO | Registered: January 31, 2006Reply With QuoteReport This Post
Platinum Member
posted Hide Post
Here is basically what I wound up doing:

DEFINE FILE CAR
AUDITLINK1/A50= 'http://www.google.com/';
AUDITLINK2/A255= '<a href='||''''|| AUDITLINK1 | '''' | '>' || CAR.MODEL ||'</a>';
END

TABLE FILE CAR
PRINT
AUDITLINK2 AS 'Hyperlink Field'

ON TABLE PCHOLD FORMAT EXL2K
END


Production - 7.6.4
Sandbox - 7.6.4
 
Posts: 241 | Location: Bethesda, MD | Registered: August 14, 2007Reply With QuoteReport This Post
Guru
posted Hide Post
ColdWhiteMilk's solution works better because all the links are coming from a file.
Thank you both.

Hua


Developer Studio 7.6.11
AS400 - V5R4
HTML,PDF,XLS
 
Posts: 305 | Location: Winnipeg,MB | Registered: May 12, 2008Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED] Hyperlink as Excel Field Value

Copyright © 1996-2018 Information Builders, leaders in enterprise business intelligence.