Focal Point
How to insert image in report records

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/7751078331

July 04, 2005, 11:03 AM
<rsaini>
How to insert image in report records
In a report I want to compare the sales figure of two quarters and display the result as upArrow if current sales is higher and downArrow if sales is less. How to put the uparrow and downarrow image in report against records.

I am new to webFocus please suggest
July 04, 2005, 02:40 PM
reFOCUSing
What is your output? The reason I ask this is becasue displaying images HTML and EXL2K are different then PDF.

Do something like this for HTML and EXL2K:
COMPUTE IMAGE/A20 = IF SALES LE 5000 THEN '<img src="down.jpg">' ELSE '<img src="up.jpg">';

Image in the body of a report in PDF cannot be done. The only way I've seen this done before was by using a wingding font.
July 05, 2005, 05:31 AM
<rsaini>
Thanks a lot CurtisA, It workout.. Smiler
September 11, 2006, 12:55 PM
Ernst
Hi there!
I don't know how to work with symbols (e.g. wingding) in a PDF. can someone explain it to me ;-)
i would like to do someting like:

TENDENZ_M/A1 = 	IF UNTERDECKUNG EQ UNTERDECKUNG_M THEN '=' ELSE
				IF UNTERDECKUNG LT UNTERDECKUNG_M THEN '^' ELSE
				IF UNTERDECKUNG GT UNTERDECKUNG_M THEN 'v' ELSE 'o';

and instead of "=", "v" ... i would like wingding symbols...

please help!! :-)


WF 711 - Win2000 - PDF, EXL2K - HTML
September 11, 2006, 02:02 PM
susannah
wingding is a font




In Focus since 1979///7706m/5 ;wintel 2008/64;OAM security; Oracle db, ///MRE/BID
September 11, 2006, 05:08 PM
Nightowl
Hi Ernst, Here is a sample with the famous CAR file.

TABLE FILE CAR
PRINT
CAR AS 'Car'
COMPUTE IMAGE/A20 = IF COUNTRY EQ 'ENGLAND' THEN 'J' ELSE 'L' ; AS 'Symbol'
BY
COUNTRY AS 'Country'
ON TABLE NOTOTAL
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
UNITS=IN,
SQUEEZE=ON,
ORIENTATION=PORTRAIT,
$
TYPE=REPORT,
GRID=OFF,
FONT='TIMES NEW ROMAN',
SIZE=10,
COLOR='BLACK',
BACKCOLOR='NONE',
STYLE=NORMAL,
$
TYPE=DATA,
COLUMN=N3,
FONT='WINGDINGS',
$
TYPE=TITLE,
COLUMN=N3,
FONT='TIMES NEW ROMAN',
$
ENDSTYLE
END


Using: WF 7.1.5, XP Pro, Tomcat, Self Serve
September 12, 2006, 09:54 AM
Ernst
Thank you very much!!!! ...at least it showed me the right direction ;-)

here is my working code (parts of it..)
i used the font "symbol" instead of wingdings. PDF didn't like that font ;-)

TENDENZ_M/A1 = 	IF UNTERDECKUNG EQ UNTERDECKUNG_M THEN 'Û' ELSE
				IF UNTERDECKUNG LT UNTERDECKUNG_M THEN 'Ý' ELSE
				IF UNTERDECKUNG GT UNTERDECKUNG_M THEN 'ß' ELSE ' ';
....  
TYPE=REPORT, COLUMN=TENDENZ_M,			POSITION=18.6,	FONT='SYMBOL', $

Û .... = ... equal
Ý .... ^ ... arrow up
ß .... v ... arrow down


WF 711 - Win2000 - PDF, EXL2K - HTML