[CLOSED]Drill down based on the conditional styling
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,
WebFOCUS 8104/7703/769/764, Windows 7, Oracle 11g, DB2, QAD
May 11, 2016, 07:54 AM
Ricardo Augusto
Very weird.
It works fine on HTML output.
WebFOCUS 8.1.05 / APP Studio
May 11, 2016, 08:05 AM
MartinY
Hi koti,
It work properly in WF77, not in WF8
Maybe a bug for TechSupport...
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
May 11, 2016, 08:40 AM
Francis Mariani
This code works in v8.0.08.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
May 11, 2016, 08:42 AM
Francis Mariani
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
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
May 11, 2016, 09:13 AM
koti
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.
WebFOCUS 8104/7703/769/764, Windows 7, Oracle 11g, DB2, QAD
May 11, 2016, 11:08 AM
Francis Mariani
In v8.0.08 it only has the drilldown for values greater than 10,000.
Francis
Give me code, or give me retirement. In FOCUS since 1991
Production: WF 7.7.05M, Dev Studio, BID, MRE, WebSphere, DB2 / Test: WF 8.1.05M, App Studio, BI Portal, Report Caster, jQuery, HighCharts, Apache Tomcat, MS SQL Server
May 11, 2016, 11:33 AM
MartinY
Not in WF-8.1.0.5 unfortunately
WF versions : Prod 8.2.04M gen 33, Dev 8.2.04M gen 33, OS : Windows, DB : MSSQL, Outputs : HTML, Excel, PDF In Focus since 2007
May 11, 2016, 11:44 AM
David Briars
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';