Focal Point
[FIXED in 7704] Multi-drilldown does not work properly with AHTML output

This topic can be found at:
https://forums.informationbuilders.com/eve/forums/a/tpc/f/7971057331/m/5267007516

January 21, 2012, 03:00 PM
Francis Mariani
[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.

Yours

Eran


Yours,
Eran
SRL Products

http://www.srl.co.il

January 23, 2012, 10:06 AM
Francis Mariani
Thanks!


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