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, have you thought of just doing it , putting the url string in the heading...

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

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).

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

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!

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

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.

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.

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

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,

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