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
reFOCUSingWhat 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..
September 11, 2006, 12:55 PM
ErnstHi 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!! :-)
September 11, 2006, 02:02 PM
susannahwingding is a font
September 11, 2006, 05:08 PM
NightowlHi 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
September 12, 2006, 09:54 AM
ErnstThank 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