[FIXED in 7704] Multi-drilldown does not work properly with AHTML output
When the code column is a NOPRINT, the incorrect column value is passed in the drilldown. In this example, the value of EMP_ID is not passed, the value passed is from FIRST_NAME. Remove the NOPRINT and it works.
-* File ahtml_drill1.fex
-SET &ECHO=ALL;
-DEFAULT &COUNTRY = 'FOC_NONE';
TABLE FILE EMPLOYEE
SUM
EMP_ID NOPRINT
BY LAST_NAME
BY FIRST_NAME
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT AHTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
INCLUDE = endeflt,
$
TYPE=REPORT,
LINES-PER-PAGE=20,
$
TYPE=DATA,
COLUMN=LAST_NAME,
TARGET='_self',
DRILLMENUITEM='DrillDown a',
FOCEXEC=ahtml_drilla( \
EMP_ID=EMP_ID \
),
DRILLMENUITEM='DrillDown b',
FOCEXEC=ahtml_drillb( \
EMP_ID=EMP_ID \
),
$
ENDSTYLE
END
This message has been edited. Last edited by: Francis Mariani,
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
January 22, 2012, 10:07 AM
WF_IL
Hi
We had the same problem and reported this issue. As far as I know its supposed to be fixed in 7704.