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. I want to use below 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 for me. Can anybody help?

 
Regards,
Jawad Hassan  

 

Hi,

I am not getting any error instead I want to create a new report using this definition which I can't do currently.

Kind Regards,
Jawad Hassan

Does anyone know if CUIC Standard contains all of the reports that were in WebView? Also, can you import Webview reports into CUIC Standard?

 
EDIT - 'Documentation' of this CCR CDN. 

In that case you should be able to create the report definition fine. How are you creating the report definition then? If you are leaving the :calltype_list, :start_date and :end_date in the query then you need to create it as an Anonymous Block definition and then associate the Call Types value list to the CallTypeID field.

Cheers,
Nathan Luk
Solutions Consultant
M : +61 437 807 719
P : +61 2 9078 8112
F : +61 2 9078 8120

[http://www.ucommgroup.com.au/templates/theme606/images/logo.png]<http://www.ucommgroup.com.au/>
This e-mail transmission is intended only for the addressee and may contain confidential or privileged information. Confidentiality and privilege are not waived if you are not the intended recipient of this e-mail, nor may you use, review, disclose, disseminate or copy any information contained in or attached to it. If you received this e-mail in error please delete it and any attachments and notify us immediately by reply e-mail. Ucomm Group does not warrant that any attachments are free from viruses or other defects. You assume all liability for any loss, damage or other consequences which may arise from opening or using the attachments.

From: Cisco Developer Community Forums <cdicuser@developer.cisco.com<mailto:cdicuser@developer.cisco.com>>
Reply-To: "cdicuser@developer.cisco.com<mailto:cdicuser@developer.cisco.com>" <cdicuser@developer.cisco.com<mailto:cdicuser@developer.cisco.com>>
Date: Tue, 7 Feb 2012 02:13:59 -0500
To: "cdicuser@developer.cisco.com<mailto:cdicuser@developer.cisco.com>" <cdicuser@developer.cisco.com<mailto:cdicuser@developer.cisco.com>>
Subject: New Message from Jawad Hassan in Contact Center Reporting (CCR) - Contact Center Reporting: RE: Re: New Message from Jawad Hassan in Contact Center Reporting (CCR) - C

Jawad Hassan has created a new message in the forum "Contact Center Reporting":

--------------------------------------------------------------
Hi,

I have checked that i have CUIC premium.

Regards,
Jawad Hassan

Sounds like you only have CUIC standard. You need CUIC premium in order to create your own report definitions.

Cheers,

Nathan Luk
M: 0437807719
E: nluk@ucommgroup.com.au<mailto:nluk@ucommgroup.com.au>

On 06/02/2012, at 22:32, "Cisco Developer Community Forums" <cdicuser@developer.cisco.com<mailto:cdicuser@developer.cisco.com>> wrote:

> Jawad Hassan has created a new message in the forum "Contact Center Reporting":
>
> --------------------------------------------------------------
> Hi,
>
> I am not getting any error instead I want to create a new report using this definition which I can't do currently.
>
> Kind Regards,
> Jawad Hassan
> --
> To respond to this post, please click the following link:
>
> <http://developer.cisco.com/web/ccr/forums/-/message_boards/view_message/5107235>
>
> or simply reply to this email.

--
To respond to this post, please click the following link:

<http://developer.cisco.com/web/ccr/forums/-/message_boards/view_message/5109697>

or simply reply to this email.

You can hire a partner that has a premium version of CUIC to do this for you. It's can be done without a premium version by exporting/editing/reimporting the template and report definitions, but but it's very tricky and not something I would recommend you do in a production environment.