Hello,

is it possible to embed an image to a column depending on a value in the output format HTMTABLE??

Christian

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

Quite straight forward Christian

create a COMPUTE or DEFINE

The images should reside on the apppath

change /appname/ to the name of your app folder

The concatenated column SRC should contain the actual file name i.e. image.gif
This could come from your data or be a defined or computed column

 
TABLE FILE CAR
SUM   
     COMPUTE SRC/A25= IF DEALER_COST LE 4000 THEN 'red.gif' ELSE
                        IF DEALER_COST LE 5000 THEN 'yellow.gif' ELSE 'green.gif'; NOPRINT

     COMPUTE IMAGE/A200 = '<img src="/approot/appname/' || SRC ||'"  style="width:25px; height:25px;" >'; AS ''
     DEALER_COST
     RETAIL_COST
BY COUNTRY
BY MODEL
BY CAR
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTMTABLE
ON TABLE SET STYLE *
$

ENDSTYLE
END
-RUN
-HTMLFORM BEGIN
!IBI.FIL.REPORT;
-HTMLFORM END

Hello JG,

your solution works great!!!! we pointed a drilldown on the image, now we have a blue border around the image. how can we avoid this behavior??

Christian

Christian,

Basic html, add a border attribute to the style.

border:none;

Perfect!!! I think in most cases a beginner like me thinks too complicated!!
Christian

Hi JG
That's really neat!
Can I do the same into Excel and PDF?
Bob

Hi again

Looks like Susannah solved the PDF version in 2007. If you search for "images in pdf report flag" you'll find it

Just need to do Excel now!

Bob