IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    Embed HTML image link in a subfoot?
Go
New
Search
Notify
Tools
Reply
  
-star Rating Rate It!  Login/Join 
Master
Posted
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 Win2003 Server running Webfocus 7.6.2 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
 
Posts: 540 | Registered: January 04, 2007Reply With QuoteEdit or Delete MessageReport This Post
Master
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

WebFOCUS 7.1.3 /// Windows 2003 Server /// Oracle Data Sources /// HTML, PDF, EXCEL Output
 
Posts: 933 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Reply With QuoteEdit or Delete MessageReport This Post
Master
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. Roll Eyes


Thanks!

Mickey

WebFOCUS 7.1.3 /// Windows 2003 Server /// Oracle Data Sources /// HTML, PDF, EXCEL Output
 
Posts: 933 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Reply With QuoteEdit or Delete MessageReport This Post
Master
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 5.2.2 thru 7.6.x
Windows, Unix, MVS
 
Posts: 648 | Location: Richmond, VA | Registered: January 31, 2006Reply With QuoteEdit or Delete MessageReport This Post
Master
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. Music

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


Thanks!

Mickey

WebFOCUS 7.1.3 /// Windows 2003 Server /// Oracle Data Sources /// HTML, PDF, EXCEL Output
 
Posts: 933 | Location: Gaithersburg, MD, USA | Registered: May 07, 2003Reply With QuoteEdit or Delete MessageReport This Post
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



Env 1: WebFOCUS 5.3.2 Servlet - MRE/BID/Self Service/ReportCaster - MS Windows Server 2003 - IIS/New Atlanta ServletExec - MS SQL Server 2000 - DataMigrator 5.3.4
Env 2: WebFOCUS 7.6.5 Servlet - MRE/BID/Self Service - MS Windows XP SP2 - Apache Tomcat/5.5.25 - MS SQL Server 2000
Env 3: WebFOCUS 5.3.3 CGI - Self Service - AIX 5.2 - IBM DB2
Output formats: HTML, Excel 2000 and PDF
 
Posts: 3291 | Location: Toronto, Ontario, Canada | Registered: April 27, 2005Reply With QuoteEdit or Delete MessageReport This Post
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


Old FOCUS coders never die, they just become functionally stable. (Tony A Wink)

Current Client: WebFOCUS 7.6.2 Win XP SP2/IIS 6/Tomcat 5.5 - MRE / BID MS SQL / Oracle - DevStudio 7.6.6 7.1.6
Local: WebFOCUS 7.6.6 7.1.6 on Win XP SP2/Apache/Tomcat 5.5 - Self Service
 
Posts: 2823 | Location: England U.K. (Freelance) | Registered: April 08, 2004Reply With QuoteEdit or Delete MessageReport This Post
Master
Posted Hide Post
Good work, Thanks!


Prod: Single Win2003 Server running Webfocus 7.6.2 Reporting server Web server IIS6/Tomcat, AS400 DB2 database.
 
Posts: 540 | Registered: January 04, 2007Reply With QuoteEdit or Delete MessageReport This Post
 Previous Topic | Next Topic powered by eve community  
 

IB - Developer Center    Forums  Hop To Forum Categories  FOCUS/WebFOCUS    Embed HTML image link in a subfoot?

Copyright © 1996-2008 Information Builders, leaders in enterprise business intelligence.