Problem in creating customized report using report definition

Unanswered Question
Jan 24th, 2012
User Badges:

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?

  • 1
  • 2
  • 3
  • 4
  • 5
Overall Rating: 0 (0 ratings)
Loading.
Amer rajai Sha'er Thu, 01/26/2012 - 00:57
User Badges:
  • Gold, 750 points or more

Hello,


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


Amer

Jawad Hassan Thu, 01/26/2012 - 22:08
User Badges:

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.

Jawad Hassan Sun, 02/05/2012 - 23:07
User Badges:

Hi,


Can anybody respond to this? It's urgent.


Regards,

Jawad Hassan

Actions

This Discussion