[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