[SOLVED] Embedding image next to Column Title

September 21, 2004, 05:35 AM

<Kalyan>

Hi,
Is it possible to embed an image next to a column title? The idea is to have an image ( arrow pointing upwards) next to all columns which can be sorted. clicking on the image will sort the column by ascending or descending and the image direction will also change !!! Any pointers on how to do this ???

Regards,
Kalyan.

This message has been edited. Last edited by: FP Mod Chuck,

September 21, 2004, 06:16 PM

susannah

sure
your AS phrase, which puts a nice title on your column, can contain an image tag
BY MODEL AS 'my model'
..would become
BY MODEL AS '<IMG SRC="http://yourserver/images/uparrow.gif"> click here'

That gets the image in, now you'll have to keep track of your sorting. so your columntitle will have a drilldown, and your as phrase can be an &VAR and you set your &VAR to be the UP arrow to begin, and you create a second &VAR which is the opposite of what your current &VAR is set to, so if your &var is up then &varother is down.
and then your drilldown passes thru &varother as the next setting of &var.
Clear as mud?

September 22, 2004, 05:18 AM

<Kalyan>

Thanks.That worked picture perfect!!!!

quote:
Originally posted by susannah:
[qb] sure
your AS phrase, which puts a nice title on your column, can contain an image tag
BY MODEL AS 'my model'
..would become
BY MODEL AS '<IMG SRC="http://yourserver/images/uparrow.gif"> click here'

That gets the image in, now you'll have to keep track of your sorting. so your columntitle will have a drilldown, and your as phrase can be an &VAR and you set your &VAR to be the UP arrow to begin, and you create a second &VAR which is the opposite of what your current &VAR is set to, so if your &var is up then &varother is down.
and then your drilldown passes thru &varother as the next setting of &var.
Clear as mud? [/qb]

April 29, 2018, 02:53 PM

KLH

Thanks Susannah,

This sounds good. Where does the image need to reside? I am using 8202M.

I have the following code. I want to be able to see and click on my image. I have both images in my 'Common' application folder in a common domain. Both are accessible from within this fex.

DEFINE FILE CAR
MyImage/A128 = '[IMG]UpSizeArrow.gif[/IMG]' ;
END
TABLE FILE CAR
HEADING
"Click on this image, <MyImage to do something"
SUM 
DCOST AS '[IMG]IBFS:/WFC/Repository/Common/Images/UpSizeArrow.jpg[/IMG]D Cost'
RCOST AS '[IMG]IBFS:/WFC/Repository/Common/Images/UpSizeArrow.gif[/IMG]R Cost'
BY COUNTRY
END

Here are the images I am using and the result of my report. If the images do not show up in IE, try it in Chrome.
JPG:

GIF:

Report:

Kenneth

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

April 04, 2019, 12:11 PM

Doug

Welcome to Focal Point... Put the images in 'An Accessible App Folder', Try this:

TABLE FILE ibisamp/car
SUM DCOST RCOST
COMPUTE 
Image/A250V=IF DCOST GT 54000 THEN '<img src="/ibi_apps/run/ibfs?IBFS_path=/'An Accessible App Folder'/up_arrow_small_green.png" height=20 width=20>'
       ELSE IF DCOST GT 37000 THEN '<img src="/ibi_apps/run/ibfs?IBFS_path=/'An Accessible App Folder'/down_arrow_small_red.png" height=20 width=20>'
       ELSE                        '<img src="/ibi_apps/run/ibfs?IBFS_path=/'An Accessible App Folder'/equal_sign_gray.png"      height=20 width=20>' ;
BY COUNTRY
FOOTING
"The relevence of the image is totally irrelevent in relatio to th edata."
ON TABLE PCHOLD FORMAT HTML
ON TABLE NOTOTAL
ON TABLE SET CACHELINES 100
ON TABLE SET GRWIDTH 1
ON TABLE SET AUTOFIT OFF
ON TABLE SET STYLE *
GRID=OFF,$
TYPE=FOOTING, SIZE=9, $
ENDSTYLE
END

Height and Width is only needed to adjust the size as needed if the original size is not appropriate.