[SOLVED] Way to put a hyperlink in the report header in Excel output format?
Is there a way for me to put a html hyperlink in the report header for my report that outputs in Excel?
I would like it to appear as a clickable hyperlink in Excel when the user runs the report.
It would be really nice if I could also substitute text to mask the long URL.
Thoughts?This message has been edited. Last edited by: Kerry,
Rob M. Target Corporation
WF 7.1.4
August 19, 2008, 07:13 PM
susannah
Rob, have you thought of just doing it , putting the url string in the heading...
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
August 19, 2008, 10:45 PM
susannah
TABLE FILE CAR BY COUNTRY SUM SALES ON TABLE SUBHEAD "CLICK HERE" ON TABLE PCHOLD FORMAT EXL2K ON TABLE SET STYLE *
TYPE=TABHEADING, LINE=1, OBJECT=TEXT, ITEM=1, TARGET='_blank', URL=HTTP://WWW.USPS.COM, $ ENDSTYLE END
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
August 20, 2008, 09:51 AM
Doug
Susanna: Excellent! I used this method at USDA to embed an "Export to PDF or Excel" link in the heading of HTML reports to drilldown on itself and pass either P (for PDF) or X (for Excel). I change the link to null, through DM logic, so the link does not appear in the PDF or Excel outputs (as per clients request).
In FOCUS Since 1983 ~ from FOCUS to WebFOCUS. Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
August 20, 2008, 09:59 AM
Rob M.
quote:
Originally posted by susannah: Rob, have you thought of just doing it , putting the url string in the heading...
I want it to be a clickable link....
I will try your other method below.
Thanks
Rob M. Target Corporation
WF 7.1.4
August 20, 2008, 10:05 AM
Rob M.
quote:
Originally posted by susannah: TABLE FILE CAR BY COUNTRY SUM SALES ON TABLE SUBHEAD "CLICK HERE" ON TABLE PCHOLD FORMAT EXL2K ON TABLE SET STYLE *
TYPE=TABHEADING, LINE=1, OBJECT=TEXT, ITEM=1, TARGET='_blank', URL=HTTP://WWW.USPS.COM, $ ENDSTYLE END
Works GREAT! THANK YOU SO MUCH!
Rob M. Target Corporation
WF 7.1.4
December 17, 2012, 03:44 PM
phoenixfox
Hi all. I'd like to ask the expert, Susannah, if this method would work if I wanted to include a clickable link in my excel output. I want to include the link in a defined paragraph. -*********************************************** DEFINE FILE TABLE1 PARAGRAPH2/A1000 = IF LAST_NAME EQ 'Smith' THEN 'Contact the Office of the Registrar'; -*********************************************** If I want the "Office of the Registrar" to be a clickable link, how can I do that? Thanks
WebFOCUS 7.6 Windows, All Outputs
December 17, 2012, 04:01 PM
Francis Mariani
quote:
PARAGRAPH2
Where is PARAGRAPH2 in the report? If it's in the report heading, it should be done very similarly to what susannah suggested.
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
December 17, 2012, 04:26 PM
susannah
DEFINE FILE TABLE1
emailaddress/A100='<a href="mailto:registrar@nyu.edu">office of the registrar</a>';
...
END
then
HEADING
"If you have any questions regarding the any of this stuff, please contact <+0><emailaddress<+0>and you will receive a response by next Tuesday."
and then
TYPE=HEADING,LINE=1,ITEM=2,STYLE=BOLD,COLOR=RED,$
or whatever you wanna do.
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
December 18, 2012, 05:19 AM
Tony A
If I read the post correctly, I think what is being asked for here is to include a hyperlink within the text within a cell like this -
TABLE FILE CAR
PRINT COMPUTE PARAGRAPH/A70 = 'Some text, <a href="http://www.google.co.uk">link</a>, some more text.';
BY COUNTRY
ON TABLE SET PAGE NOLEAD
ON TABLE SET HTMLCSS ON
ON TABLE PCHOLD FORMAT EXL2K
END
The answer is no, you can't even do that in Excel (allegedly). So, the general rule will be that if Excel doesn't support it then output to Excel probably won't do either.
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10
December 18, 2012, 10:05 AM
susannah
SUM SALES AND
COMPUTE emailaddress/A100= '<a href="mailto:me@someplace.com">me</a>';
BY COUNTRY BY MODEL
ON TABLE PCHOLD FORMAT EXL2K
works for me in excel; link opens outlook fine.
(code keeps getting screwed up ...i think this will survive)This message has been edited. Last edited by: susannah,
In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
December 18, 2012, 10:39 AM
Tony A
But that is the entire text within a cell and not a portion of it?
Perhaps PhoenixFox will enlighten us as to what was really meant....
T
In FOCUS since 1986
WebFOCUS Server 8.2.01M, thru 8.2.07 on Windows Svr 2008 R2
WebFOCUS App Studio 8.2.06 standalone on Windows 10