Focal Point
[CASE OPEN] WF 8.0.08 - Accordion reports are very slow, and buggy

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

November 26, 2014, 04:43 PM
Francis Mariani
[CASE OPEN] WF 8.0.08 - Accordion reports are very slow, and buggy
Here's a fex, built using the GUI:

TABLE FILE CENTORD
SUM
     CENTORD.PINFO.QUANTITY
     CENTORD.INVSEG.QTY_IN_STOCK
BY  LOWEST CENTORD.OINFO.PLANT
BY  LOWEST CENTORD.STOSEG.STATE
BY  LOWEST CENTORD.STOSEG.STORENAME
BY  CENTORD.INVSEG.PRODCAT
BY  CENTORD.INVSEG.PRODNAME
WHERE CENTORD.OINFO.PLANT EQ 'BOS';
ON TABLE SET PAGE-NUM NOLEAD
ON TABLE SET EXPANDBYROW 4
ON TABLE NOTOTAL
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = IBFS:/EDA/EDASERVE/_EDAHOME/ETC/endeflt.sty,
$
ENDSTYLE
END


This outputs a report of 352 lines. Try expanding some of the lower levels of the accordion. Then collapse the top level ("BOS") - it's extremely slow. And many of the lower levels do not get collapsed. This fex illustrates two bugs in one.

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