Cross Tab Reporting

Version 1
    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