[CLOSED] How can I add an image like the column 4 image to the total line
TABLE FILE 0401_S SUM Membership MEM_CHG NOPRINT TREND AS 'Trend' PER_MEM AS '% of Mbsp' FEMALE_PCT AS '% Female' MALE_PCT AS '% Male' AVG_AGE AS 'Avg Age' PAID_PMPM/P20.2:C AS 'PMPM' BY EMPLOYERDESC_ATTRIBUTE AS 'PPG' ON TABLE PCHOLD FORMAT HTML ON TABLE SUBTOTAL SUM. Membership AVE. PER_MEM AVE. FEMALE_PCT AVE. MALE_PCT AVE. AVG_AGE SUM. PAID_PMPM ON TABLE SET PAGE-NUM NOLEAD ON TABLE SET SQUEEZE ON ON TABLE SET EMPTYREPORT ON ON TABLE SET HTMLCSS ON ON TABLE SET CACHELINES 100 ON TABLE SET GRWIDTH 1 ON TABLE SET STYLE * INCLUDE=IBFS:/WFC/Repository/WF_Style/ConiferBase_FR.sty,$ TYPE=REPORT, TITLETEXT=&WF_TITLE.QUOTEDSTRING, SUMMARY=&WF_SUMMARY.QUOTEDSTRING, ORIENTATION=LANDSCAPE, $ TYPE=HEADING, JUSTIFY=CENTER, FONT='ARIAL', SIZE=11, COLOR=RGB(75 75 75), $ TYPE=DATA ,COLUMN=N4 ,BORDER-RIGHT=ON ,BORDER-RIGHT-COLOR=RGB(0 0 0), $ DEFMACRO=Condition_1, MACTYPE=RULE, WHEN=N3 GT 0, $ DEFMACRO=Condition_2, MACTYPE=RULE, WHEN=N3 LT 0, $ DEFMACRO=Condition_3, MACTYPE=RULE, WHEN=N3 EQ 0, $ TYPE=DATA, COLUMN=N4, MACRO=Condition_1, IMAGE=IBFS:/WFC/Repository/Images/kpi_indicators/RedUpArrow.gif, SIZE=(.15 .15), $ TYPE=DATA, COLUMN=N4, MACRO=Condition_2, IMAGE=IBFS:/WFC/Repository/Images/kpi_indicators/GreenArrowDown.gif, SIZE=(.15 .15), $ TYPE=DATA, COLUMN=N4, MACRO=Condition_3, IMAGE=IBFS:/WFC/Repository/Images/kpi_indicators/YellowDash.gif, SIZE=(.18 .12), $ ENDSTYLEThis message has been edited. Last edited by: FP Mod Chuck,
8201
September 09, 2019, 03:23 PM
pav
Hello Sherrihe, Can could be more specific,
If you want the image in as a column then you can put it in define/compute field.
DEFINE FILE CAR IMAGE/A100=IF COL_1 EQ 1 THEN 'IMAGE_1.JPG' ELSE IF COL_1 EQ 2 THEN 'IMAGE_2.JPG' ELSE 'IMAGE_3.JPG'; END
I don't really understand, you need images in footing?
September 10, 2019, 09:03 AM
sherrihe
I need an image on the ON TABLE SUBTOTAL line between SUM. Membership and AVE. PER_MEM that show s an up arrow, down arrow or even symbol based on the MEM_CHG value that is not displayed since it is a number.