Cisco Support Community
cancel
Showing results for 
Search instead for 
Did you mean: 
Community Member

Problem in creating customized report using report definition

Hi,

I am using CUIC 8.5 for report customization. I won't be able to create a customized report using my own report definition. Can anybody help?

4 REPLIES

Problem in creating customized report using report definition

Hello,

Can you please share more information , if possible to share the report definition you create ?

Amer

Community Member

Re: Problem in creating customized report using report definitio

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.

Community Member

Problem in creating customized report using report definition

Hi,

Can anybody respond to this? It's urgent.

Regards,

Jawad Hassan

Problem in creating customized report using report definition

Jawad,

You might want to post your query here http://developer.cisco.com/web/ccr/forums/-/message_boards?_19_mbCategoryId=1490408

I see good response there.

GP.

777
Views
0
Helpful
4
Replies
CreatePlease to create content