Has anyone attempted to build a Cross Tab report using CUIS 7.5.(4)
Example
Month 1 Month 2 Month 3 Month 4 Total
Call Type 1 10 10 10 10 40
Call Type 2 20 20 20 20 80
Total 30 30 30 30 120
Any assistance would be appreciated....
For cross tab Reports can be generated in cuis using anonymous block with query like this
Select cast(CallTypeID as varchar),
sum(case when month(DateTime)= 1 then 1 else 0 end) as Month1,
sum(case when month(DateTime)= 2 then 1 else 0 end) as Month2,
sum(case when month(DateTime)= 3 then 1 else 0 end) as Month3,
sum(case when month(DateTime)= 4 then 1 else 0 end) as Month4,
count(*) as Total from
Termination_Call_Detail
group by cast(CallTypeID as varchar)
union
Select 'Total',
sum(case when month(DateTime)= 1 then 1 else 0 end) as Month1,
sum(case when month(DateTime)= 2 then 1 else 0 end) as Month2,
sum(case when month(DateTime)= 3 then 1 else 0 end) as Month3,
sum(case when month(DateTime)= 4 then 1 else 0 end) as Month4,
count(*) as Total from
Termination_Call_Detail
Contact Center Reporting 
