Embed HTML image link in a subfoot?

I'm getting a syntax error on this in my fex:
...
ON TABLE SUBFOOT
"&DATE<+0> <+0>&TOD"
"<a href=""http://www.x.com/nextpage.htm""><img src=""next.jpg"" border="0"></a>"
...

Is there any way to make webfocus ignore the <a character? It's looking for an amper when I run it.

Thanks!

Prod: Single Windows 2008 Server running Webfocus 7.7.03 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.

Posts: 611 | Registered: January 04, 2007

mgrackin

Virtuoso

posted

Hide Post

There are a two ways to do this which use the same technique. Take the HTML code and put it in either a DEFINE or COMPUTE. I recommend a COMPUTE since it will be calculate fewer times.

Put the following in your code.

COMPUTE NEXTBUTN/A100='<a href="http://www.x.com/nextpage.htm"><img src="next.jpg" border="0"></a>'; NOPRINT

Then use the COMPUTE in your SUBFOOT.

ON TABLE SUBFOOT
"&DATE<+0> <+0>&TOD"
"<NEXTBUTN"

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

Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011

Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003

Ignored post by mgrackin posted

Show Post

mgrackin

Virtuoso

posted

Hide Post

I have to correct my previous post. You can only do this with either a COMPUTE or DEFINE. The DM variable method does not work. Sorry for the confusion. I have not had my coffee yet today.

Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011

Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003

Ignored post by mgrackin posted

Show Post

Tom Flynn

Expert

posted

Hide Post

Hi Mickey,

Sure you can, do it all the time:

TYPE=SUBFOOT, IMAGE='&GIF_FILE.EVAL', POSITION=(+.35 +.40), SIZE=(9.500000 3.000000),$

Just FYI...

Tom

Tom Flynn
WebFOCUS 8.1.05 - PROD/QA
DB2 - AS400 - Mainframe

Posts: 1972 | Location: Centennial, CO | Registered: January 31, 2006

Ignored post by Tom Flynn posted

Show Post

mgrackin

Virtuoso

posted

Hide Post

Tom,

You are correct that this will work as well. I fell into the trap of the myopic view and only corrected the code that was given. I again blame it on no coffee yet.

In order for your suggestion to be complete you need to add URL=... to support the hyperlink.

Thanks!

Mickey

FOCUS/WebFOCUS 1990 - 2011

Posts: 995 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003

Ignored post by mgrackin posted

Show Post

Francis Mariani

Expert

posted

Hide Post

Actually, it's TABFOOTING for a ON TABLE SUBFOOT, and you can't do exactly what Jason wants.

TABLE FILE CAR
SUM
SALES
BY COUNTRY
ON TABLE SUBFOOT
"&DATE <+0> <+0>&TOD"
"1"
ON TABLE SET STYLE *
type=tabfooting, color=blue, 
IMAGE=http://www.informationbuilders.com/images/bulletin.jpg,$
type=tabfooting, line=1, url=http://www.help.com, $
END

Gives you an image and a hyperlink, but the hyperlink is not on the image. I think you simply have to use Mickey's idea and DEFINE a field that is then embedded in the SUBFOOT:

DEFINE FILE CAR
IMAGELINK/A200 = 
'<A HREF="http://www.informationbuilders.com/"><IMG SRC="http://www.informationbuilders.com/images/bulletin.jpg" BORDER=0></A>';
END

TABLE FILE CAR
SUM
SALES
BY COUNTRY
ON TABLE SUBFOOT
"&DATE <+0> <+0>&TOD"
"<IMAGELINK"
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

Show Post

Tony A

Expert

posted

Hide Post

Jason,

Because nobody's actually said why you can't embed the HTML as you wanted, I'll tell you. It's because the leading carat < tells WF that a fieldname follows. If you don't have a field named "A" then you get an error.

You might be able to fool WF into passing the HTML for a left carat by using the "&|lt;" instead of the < but as I haven't tried it you'll have to test it out.

Incidently using the & lt; is how I get the < in this post.

Good luck

T