Focal Point Banner


As of December 1, 2020, Focal Point is retired and repurposed as a reference repository. We value the wealth of knowledge that's been shared here over the years. You'll continue to have access to this treasure trove of knowledge, for search purposes only.

Join the TIBCO Community
TIBCO Community is a collaborative space for users to share knowledge and support one another in making the best use of TIBCO products and services. There are several TIBCO WebFOCUS resources in the community.

  • From the Home page, select Predict: WebFOCUS to view articles, questions, and trending articles.
  • Select Products from the top navigation bar, scroll, and then select the TIBCO WebFOCUS product page to view product overview, articles, and discussions.
  • Request access to the private WebFOCUS User Group (login required) to network with fellow members.

Former myibi community members should have received an email on 8/3/22 to activate their user accounts to join the community. Check your Spam folder for the email. Please get in touch with us at community@tibco.com for further assistance. Reference the community FAQ to learn more about the community.


Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Display an image in a report

Read-Only Read-Only Topic
Go
Search
Notify
Tools
[SOLVED]Display an image in a report
 Login/Join
 
Guru
posted
I have saved a file called circle_red.png in three different places.

On the EDASERVE server, under the application folder baseapp

In the repository in the EnclaraPharmacia folder

In the Web Applications under the folder _shared

I have tried multiple defines but I can't seem to get the correct source address. I am using version 8.0.9. can someone tell me what I am missing?

Thank you

 

DEFINE FILE CAR
-*	CIRCLE_RED/A80 = '<IMG SRC=_shared/circle_red.png>';
-*	CIRCLE_RED/A80 = '<IMG SRC=approot/baseapp/circle_red.png>';
-*	CIRCLE_RED/A80 = '<IMG SRC=baseapp/circle_red.png>';
-*	CIRCLE_RED/A80 = '<IMG SRC=IBFS:/WFC/Repository/EnclaraPharmacia/circle_red.png>';
-*	CIRCLE_RED/A80 = '<IMG SRC=EnclaraPharmacia/circle_red.png>';

END

TABLE FILE CAR
PRINT
     MODEL
	 CIRCLE_RED
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END
 

This message has been edited. Last edited by: Jay Potter,


WebFocus 8.1.5
iSeries/Windows
DB2/SQL/Access
Dev Studio
App Studio
Maintain
ReportCaster
 
Posts: 341 | Location: Pembroke NH/Jericho NY | Registered: June 15, 2011Report This Post
Guru
posted Hide Post
I actually got this to work, but I can't it to work in AHTML. Can you display an image in the report using active HTML?

DEFINE FILE CAR

CIRCLE_RED/A80 = ' ';

END

TABLE FILE CAR
PRINT
MODEL
CIRCLE_RED
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$

TYPE=DATA, COLUMN=CIRCLE_RED, IMAGE=IBFS:/WFC/Repository/EnclaraPharmacia/circle_red.png, $

ENDSTYLE
END


WebFocus 8.1.5
iSeries/Windows
DB2/SQL/Access
Dev Studio
App Studio
Maintain
ReportCaster
 
Posts: 341 | Location: Pembroke NH/Jericho NY | Registered: June 15, 2011Report This Post
Virtuoso
posted Hide Post
Hey Jay,

You may also try:

TYPE=REPORT,
     IMAGE=http://server.domain.com/approot/images/image.gif,
     POSITION=(+0 +0),
$


This works for us. Of course you can modify it to be column-specific. It's not necessarily an AHTML report, but could possibly work that way I would think.


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1113 | Location: USA | Registered: January 27, 2015Report This Post
Guru
posted Hide Post
The code you are using is when the image is in the header. I am looking at showing an image in each record depending on a macro condition. I do have it working in HTML. In AHTML is shows nothing. Not even an "X" as if it can't find the image. It does not seem like it is acknowledging the and image should be displayed.

Thank You for responding.


WebFocus 8.1.5
iSeries/Windows
DB2/SQL/Access
Dev Studio
App Studio
Maintain
ReportCaster
 
Posts: 341 | Location: Pembroke NH/Jericho NY | Registered: June 15, 2011Report This Post
Virtuoso
posted Hide Post
Sounds good. No sweat.

Boom:

Solution ...possibly.


8.2.02M (production), 8.2.02M (test), Windows 10, all outputs.
 
Posts: 1113 | Location: USA | Registered: January 27, 2015Report This Post
Expert
posted Hide Post
The thing to remember is that the image must be accessible to the browser. So when you get the dreaded "x" for image cannot be displayed, always right click and view the url to ensure that it is "pukka".

If you're not even getting the "x" then right click where it should be or investigate the html output via "view source". Posting that might enable us to point you in the right direction.

This code does produce the image in an AHTML output. My image is in the baseapp application folder.

DEFINE FILE CAR
  CIRCLE_RED/A80 = '<img src="../../approot/baseapp/circle_red.png" />';
END
TABLE FILE CAR
PRINT MODEL
	  CIRCLE_RED
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
 INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END


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 
 
Posts: 5694 | Location: United Kingdom | Registered: April 08, 2004Report This Post
Guru
posted Hide Post
Thank you for pointing me in the right direction. I was so close. I had to use approot/_shared. _shared is my Web Application folder.


WebFocus 8.1.5
iSeries/Windows
DB2/SQL/Access
Dev Studio
App Studio
Maintain
ReportCaster
 
Posts: 341 | Location: Pembroke NH/Jericho NY | Registered: June 15, 2011Report This Post
  Powered by Social Strata  

Read-Only Read-Only Topic

Focal Point    Focal Point Forums  Hop To Forum Categories  WebFOCUS/FOCUS Forum on Focal Point     [SOLVED]Display an image in a report

Copyright © 1996-2020 Information Builders