Hi,
Thanks for the reply. I have created following report definition.
SELECT Call_Type.EnterpriseName, Call_Type.Description AS DNIS, Call_Type_Interval.CallTypeID,
SUM(Call_Type_Interval.ServiceLevelCallsOffered) AS CallsOffered,
SUM(Call_Type_Interval.CallsAnswered) AS CallsAnswered,
SUM(Call_Type_Interval.TotalCallsAband) AS TotalCallsAband,
SUM(Call_Type_Interval.ServiceLevelAband) AS ServiceLevelAband,
SUM(Call_Type_Interval.ShortCalls) AS ShortCalls,
SUM(Call_Type_Interval.CallDelayAbandTime) AS CallDelayAbandTime,
SUM(Call_Type_Interval.AnswerWaitTime) AS AnswerWaitTime,
SUM(Call_Type_Interval.AnsInterval1) AS AnsInterval1,
SUM(Call_Type_Interval.AnsInterval2) AS AnsInterval2,
SUM(Call_Type_Interval.AnsInterval3) AS AnsInterval3,
SUM(Call_Type_Interval.AnsInterval4) AS AnsInterval4,
SUM(Call_Type_Interval.AnsInterval5) AS AnsInterval5,
SUM(Call_Type_Interval.AnsInterval6) AS AnsInterval6,
SUM(Call_Type_Interval.AnsInterval7) AS AnsInterval7,
SUM(Call_Type_Interval.AnsInterval8) AS AnsInterval8,
SUM(Call_Type_Interval.AnsInterval9) AS AnsInterval9,
SUM(Call_Type_Interval.AnsInterval10) AS AnsInterval10
FROM
Call_Type (nolock),
Call_Type_Interval (nolock)
WHERE Call_Type.CallTypeID = Call_Type_Interval.CallTypeID
AND Call_Type.CallTypeID in (:calltype_list)
AND Call_Type_Interval.DateTime >= :start_date
AND Call_Type_Interval.DateTime <= :end_date
GROUP BY Call_Type.EnterpriseName,
Call_Type.Description,
Call_Type_Interval.CallTypeID
For this definition i wanted to create a customized report which is apparently not possible.
