Cross Tab Reporting

Document created by cdnadmin on Jan 24, 2014
Version 1Show Document
  • View in full screen mode
This document was generated from CDN thread

Created by: Steven Maas on 05-08-2010 10:45:09 PM
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....

Subject: RE: Cross Tab Reporting
Replied by: Venkat Subbarao on 06-08-2010 03:14:45 AM
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

Attachments

    Outcomes