Hi Everyone,

I am trying to create a report in AHTML with three conditions each been indicated in different(<=5000, >5000 & >10000) and drill down from the last condition. But the drill down is getting applied for all the values. Below is the sample code for reference.

Please suggest on how to get the value drill down only for a particular condition.

 
TABLE FILE CAR 
PRINT CAR
RETAIL_COST
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET STYLE *
INCLUDE=IBFS:/FILE/IBI_HTML_DIR/javaassist/intl/EN/ENIADefault_combine.sty,$
DEFMACRO=Condition_1, MACTYPE=RULE, WHEN=N2 LE 5000, $
DEFMACRO=Condition_2, MACTYPE=RULE, WHEN=N2 GT 5000, $
DEFMACRO=Condition_3, MACTYPE=RULE, WHEN=N2 GT 10000, $
TYPE=DATA, COLUMN=N2, MACRO=Condition_1, FONT='Trebuchet MS', COLOR=RGB(25 155 25), $
TYPE=DATA, COLUMN=N2, MACRO=Condition_2, FONT='Trebuchet MS', COLOR=RGB(255 255 0), $
TYPE=DATA, COLUMN=N2, MACRO=Condition_3, FONT='Trebuchet MS', COLOR=RGB(255 0 0), DRILLMENUITEM='Update DATA', FOCEXEC=sample.fex(CAR=CAR),$
ENDSTYLE
END [QUOTE]  [/QUOTE] 

sample.fex
----------

TABLE FILE CAR
PRINT CAR COUNTRY
WHERE CAR EQ &CAR
END

 

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

Very weird.

It works fine on HTML output.

Hi koti,

It work properly in WF77, not in WF8

Maybe a bug for TechSupport...

This code works in v8.0.08.

Perhaps, this variation, without macros, will work:

TABLE FILE CAR
PRINT
CAR
RETAIL_COST
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET STYLE *
TYPE=DATA, COLUMN=RETAIL_COST, FONT='Trebuchet MS', COLOR=RGB(25 155 25), WHEN=RETAIL_COST LE 5000, $
TYPE=DATA, COLUMN=RETAIL_COST, FONT='Trebuchet MS', COLOR=RGB(255 255 0), WHEN=RETAIL_COST GT 5000, $
TYPE=DATA, COLUMN=RETAIL_COST, FONT='Trebuchet MS', COLOR=RGB(255 0 0), WHEN=RETAIL_COST GT 10000,
    DRILLMENUITEM='Update DATA', FOCEXEC=sample.fex(CAR=CAR), $
ENDSTYLE
END

I also got that . If you notice carefully the drill down is getting applied for all the values where as I need it only for the values greater than 10,000 either by using drillmenuitem or target blank.

In v8.0.08 it only has the drilldown for values greater than 10,000.

Not in WF-8.1.0.5 unfortunately

When doing conditional styling, I like to COMPUTE a 'flag' field, and use the flag in the StyleSheet.

Something like...

COMPUTE MYFLAG/A1 = IF RETAIL_COST LT 5000 THEN 'A' ELSE
                     IF RETAIL_COST LT 10000 THEN 'B' ELSE 'C';  

...then in the StyleSheet something like...

...WHEN=FLAG EQ 'A'...
...WHEN=FLAG EQ 'B'...
...WHEN=FLAG EQ 'C'...

Thanks David, your logic is working fine in WF 8104 for AHTML. Thanks again!