(CLOSED)mailto hyperlink in PDF

Platinum Member

posted

I am able o create an email hyperlink in HTML with no problem:

 emailaddress/A200V= '<a href="mailto:'|| SUPPORTEMAIL || '">' || DIVISIONCONTACT || '</a>';

But now I need to do the same in PDF. The same code does not work.

I have tried the following in the stylesheet:

 -*TYPE=SUBHEAD,
BY=REPORTINGSYSTEMNAME,
     LINE=1,
ITEM=4,
URL=emailaddress ,
$

SUPPORTEMAIL contains the email address.
so emailaddress is emailaddress/A207= 'mailto:'|| SUPPORTEMAIL ;"
That doesn't work either.
Has anyone done this in PDF and can show me the way.

Thanks!
Marilyn

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

WebFOCUS 8.1.05 Windows 7, all output

Posts: 107 | Registered: February 18, 2011

Platinum Member

posted

OK. Part of the problem solved:
I just put the field in the report and magically, when you click on it, it opens an email. The problem: When you do that, the PDF file appears as a blank report. (If I hit the back button or refresh the screen, it will come back. But that is more than I can expect from the users.)
Any idea how to keep the PDF report in the container after hitting the link? [Interestingly enough, after I refresh once, it stays there the next time I hit an email link. Odd little quirk!!]

WebFOCUS 8.1.05 Windows 7, all output

Posts: 107 | Registered: February 18, 2011

Ignored post by mpbMDE posted

Francis Mariani

Expert

posted

This seems to work (you have to substitute the hard-coded emails by your fields):

TABLE FILE CAR
SUM 
CAR.BODY.SALES
COMPUTE EMAILADDRESS/A207 = 
   'mailto:' || 'nowhere@google.com' 
|| '?cc=' || 'nobody@google.com' 
|| '&|bcc=' || 'everybody@google.com' 
|| '&|subject=' || 'WebFOCUS Report' 
|| '&|body=' || 'The%20body%20of%20the%20email'; NOPRINT

BY  CAR.ORIGIN.COUNTRY

ON TABLE SUBFOOT
" "
"Email <+0 moi"

ON TABLE PCHOLD FORMAT PDF

ON TABLE SET STYLE *
TYPE=TABFOOTING,
     LINE=2,
     OBJECT=TEXT,
     ITEM=2,
     URL=(EMAILADDRESS),
$
ENDSTYLE
END

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

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Platinum Member

posted

Thank you, Francis!!!
What I was missing is the following:

quote:
URL=(EMAILADDRESS),

You are the BEST!
Marilyn

WebFOCUS 8.1.05 Windows 7, all output

Posts: 107 | Registered: February 18, 2011

Ignored post by mpbMDE posted

Platinum Member

posted

Interestingly enough, if I create EMAILADRESS as a define, I have problems; as a COMPUTE, life is good!

WebFOCUS 8.1.05 Windows 7, all output

Posts: 107 | Registered: February 18, 2011

Ignored post by mpbMDE posted

Francis Mariani

Expert

posted

If it's a DEFINE, you have to reference the column in the report:

...
PRINT
...
EMAILADDRESS NOPRINT
...

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

Posts: 10577 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005

Ignored post by Francis Mariani posted

Platinum Member

posted

Kudos to you, Francis! I have posted here when I need help; and often, you have been the one to provide just the help I need.

Never knew how to put the subject in the email, until just now, either.

Thanks, again!

WebFOCUS 8.1.05 Windows 7, all output

Posts: 107 | Registered: February 18, 2011

Ignored post by mpbMDE posted