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]How to make the Hyperlink Work
Go
New
Search
Notify
Tools
Reply
  
[SOLVED]How to make the Hyperlink Work
 Login/Join
 
Gold member
posted
I have a report that export to an Excel format.
I need for this report to have dynamic hyperlinks based off of data in a row.
I can calculate the URL for the hyperlink, but I can't figure out how to make it so when I run the report, the value within an Excel column is a clickable hyperlink and not just the text of the URL.

Thank you in Advance.

This message has been edited. Last edited by: NewBee...WF8,


WebFOCUS 8
Windows, All Outputs
 
Posts: 66 | Registered: May 26, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
Does a Drill down work in HTML? Let's say you have a report like this, do you see a hyperlink for Country?
  TABLE FILE ibisamp/car
SUM DEALER_COST
BY COUNTRY
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/ibi_themes/Warm.sty,$
TYPE=DATA, COLUMN=COUNTRY, ALT='drill_to', TARGET='_blank', FOCEXEC=IBFS:/WFC/Repository/sandbox/drill_to.fex(COUNTRY=CAR.ORIGIN.COUNTRY), $
ENDSTYLE
END


WebFOCUS 8206, Unix, Windows
 
Posts: 1822 | Location: New York City | Registered: December 30, 2015Reply With QuoteReport This Post
Gold member
posted Hide Post
Thank you BabakNYC for your quick response.

Yes, I do see a hyperlink for country. But, what if my Output is in xlsx.


WebFOCUS 8
Windows, All Outputs
 
Posts: 66 | Registered: May 26, 2017Reply With QuoteReport This Post
Virtuoso
posted Hide Post
NewBee

Just change this line.

ON TABLE PCHOLD FORMAT XLSX


Thank you for using Focal Point!

Chuck Wolff - Focal Point Moderator
WebFOCUS 7x and 8x, Windows, Linux All output Formats
 
Posts: 1810 | Location: Customer Support | Registered: April 12, 2005Reply With QuoteReport This Post
Gold member
posted Hide Post
Thank you Chuck and BabaNYC.


WebFOCUS 8
Windows, All Outputs
 
Posts: 66 | Registered: May 26, 2017Reply With QuoteReport This Post
  Powered by Social Strata  
 

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]How to make the Hyperlink Work

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