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]

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   

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

In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.    Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206