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,

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

Thank you BabakNYC for your quick response.

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

NewBee

Just change this line.

ON TABLE PCHOLD FORMAT XLSX

Thank you Chuck and BabaNYC.