Focal Point
Drill down on expand by row report

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

November 30, 2011, 12:11 AM
JOE
Drill down on expand by row report
Is it possible to drill down on expand by row? Doesnt appear to work? Column is not underlined with hyperlink to drill. It works when I remove expand by row...what am I missing?

TABLE FILE AHTDIV
SUM 
     AHTDIV.AHTDIV.calls AS 'Calls,Ans'
     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  AHTDIV.AHTDIV.EmpDivisionName AS 'Division/SkillName'
BY  LOWEST AHTDIV.AHTDIV.SkillName
     
ON AHTDIV.AHTDIV.EmpDivisionName RECOMPUTE AS '*TOTAL'
HEADING
"PNC Call Center Average Handle Time Report"
"Between <+0>&dte<+0> and <+0>&edte"
" "
FOOTING
""
ON TABLE SET PAGE-NUM OFF 
ON TABLE SUMMARIZE AHTDIV.AHTDIV.calls AVGTalk AVGACW AVGHold AHT AS 'TOTAL'
ON TABLE PCHOLD FORMAT HTML
ON TABLE SET HTMLCSS ON
ON TABLE SET STYLE *
     INCLUDE = ENgray_theme,
$
TYPE=DATA,
     COLUMN=N1,
     FOCEXEC=group( \
     DIV=N1 \
     dte=&dte.QUOTEDSTRING \
     edte=&edte.QUOTEDSTRING \
     ),
$
TYPE=DATA,
     COLUMN=N2,
     JUSTIFY=LEFT,
$
TYPE=TITLE,
     COLUMN=N2,
     JUSTIFY=LEFT,
$
ENDSTYLE
END
  


Thanks for any assistance possible

Joe


WebFocus 7.7.02 WinXP
November 30, 2011, 10:16 AM
Doug
quote:
TYPE=TITLE,

Try using the actual field name instead of "COLUMN=N1"




   In FOCUS Since 1983 ~ from FOCUS to WebFOCUS.
   Current: WebFOCUS Administrator at FIS Worldpay | 8204, 8206
November 30, 2011, 11:38 AM
JOE
Thanks..however still no hyperlink for the drilldown trying that method. Is this a known issue for expandbyrow drill downs? I have no title and no hyperlink? Thanks,


WebFocus 7.7.02 WinXP