CUIC 9.X wrap-up data report

[rashmi814]

I am trying to customize report using CUIC that display total no. of ACD calls associated with wrap-up codes by each CSQ/Application. I could not find any stock report that gives wrap-up code associate with CSQ/application.

Thanks

[jacparke]

You are correct, there are no stock wrap up reports.  A set of wrap up reports were posted to the developer community here: Updated: Wrap Up Reports for CUIC 10.5 (not earlier!).  You may find something of value in looking at those.

Regards,

Jack Parker

[roberteliasson]

Here's one Report Definition I wrote quite a while ago.

However, it could need some improvements if you feel that it's too slow to run.

SELECT

CT.EnterpriseName as CallType,

SUM(TCD01.Wrapup) as Handled,

TCD01.WrapupData as WrapupData

FROM

(SELECT

CallTypeID,

WrapupData,

Wrapup = Count(WrapupData)

FROM Termination_Call_Detail

WHERE CallTypeID IN (:CallType)

and DateTime >= :startDate

and DateTime <= :endDate

and WrapupData is not null

GROUP BY

CallTypeID, WrapupData

) TCD01

LEFT OUTER JOIN (SELECT

CallTypeID,

EnterpriseName

FROM Call_Type

WHERE CallTypeID IN (:CallType)

GROUP BY

CallTypeID, EnterpriseName

) CT

ON CT.CallTypeID=TCD01.CallTypeID

GROUP BY

CT.EnterpriseName, TCD01.WrapupData, TCD01.CallTypeID

[Jameson Gagnepain]

That report is for UCCE... I think Rashmika is looking for a report for UCCX.

-Jameson