Focal Point
[Solved]Accordian Summarize not displaying correctly

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

October 13, 2010, 02:19 PM
JOE
[Solved]Accordian Summarize not displaying correctly
Hello:

I got everything to work correctly on my accordian report except for the summarize totals. Totals show up on expanded section (skills) instead of the first by which is EmpGroupName.

-* File skilltest.fex
ENGINE SQLMSS SET DEFAULT_CONNECTION IVB
SQL SQLMSS
EX ORBIT.dbo.AHTSkill '&dte','&edte'
;


TABLE FILE SQLOUT
PRINT
     EmpDivisionName
     EmpGroupName
     skill
     calls
     acdtime
     acwtime
     holdacdtime
WHERE skill EQ &skill.(OR(FIND SKILL IN &skill2)).select.;
ON TABLE HOLD AS DIVY
END
TABLE FILE DIVY
SUM
     calls/I11C AS 'Calls Ans'
     calls NOPRINT
     acdtime NOPRINT
     acwtime NOPRINT
     holdacdtime NOPRINT
     COMPUTE AHT/D8.2 = IF calls EQ 0 THEN 0 ELSE ( acdtime + acwtime + holdacdtime ) / calls;
     COMPUTE AVGTalk/D8.2 = IF calls EQ 0 THEN 0 ELSE acdtime / calls;
 AS 'AVG Talk'
     COMPUTE AVGACW/D8.2 = IF calls EQ 0 THEN 0 ELSE acwtime / calls;
 AS 'AVG ACW'
     COMPUTE AVGHold/D8.2 = IF calls EQ 0 THEN 0 ELSE holdacdtime / calls;
 AS 'AVG Hold'

BY EmpGroupName AS 'Group Name'

SUM
     calls/I11C AS 'Calls Ans'
     calls NOPRINT
     acdtime NOPRINT
     acwtime NOPRINT
     holdacdtime NOPRINT
     COMPUTE AHT/D8.2 = IF calls EQ 0 THEN 0 ELSE ( acdtime + acwtime + holdacdtime ) / calls;
     COMPUTE AVGTalk/D8.2 = IF calls EQ 0 THEN 0 ELSE acdtime / calls;
 AS 'AVG Talk'
     COMPUTE AVGACW/D8.2 = IF calls EQ 0 THEN 0 ELSE acwtime / calls;
 AS 'AVG ACW'
     COMPUTE AVGHold/D8.2 = IF calls EQ 0 THEN 0 ELSE holdacdtime / calls;
 AS 'AVG Hold'

BY EmpGroupName AS 'Group Name'
BY skill
HEADING
""
FOOTING
""
WHERE EmpDivisionName EQ '&DIV';
ON TABLE SET PAGE-NUM OFF
ON TABLE SET EXPANDABLE ON
ON TABLE SUMMARIZE DIVY.DIVY.calls DIVY.DIVY.calls DIVY.DIVY.acdtime DIVY.DIVY.acwtime DIVY.DIVY.holdacdtime AHT AVGTalk AVGACW AVGHold DIVY.DIVY.calls DIVY.DIVY.calls DIVY.DIVY.acdtime DIVY.DIVY.acwtime DIVY.DIVY.holdacdtime AHT AVGTalk AVGACW AVGHold AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *  


Thanks for any help possible!

-----------------------------------
One of my new co-workers help correct this issue for me. The on table total needed to be under the first by field. Thanks!

This message has been edited. Last edited by: JOE,


WebFocus 7.7.02 WinXP
October 18, 2010, 04:17 PM
Kerry
Thanks Joe for sharing the solution with all.

Cheers,

Kerry


Kerry Zhan
Focal Point Moderator
Information Builders, Inc.