Home » Fusion Middleware & Colab Suite » Business Intelligence » How to create Matrix with Group report in xml
icon1.gif  How to create Matrix with Group report in xml [message #467442] Sat, 24 July 2010 04:45
vittal_n
Messages: 10
Registered: July 2010
Location: Hyderabad
Junior Member
Hi,

i would be glad if anyone could tell me How to create Matrix with Group report layout in xml?

Here i am attaching the required design doc

below is the code
select  COST_CMPNTCLS_CODE, 
      --  crd.RESOURCES, 
        NOMINAL_COST, 
       cmm.COST_MTHD_CODE, 
      -- crd.COST_TYPE_ID,
        gps.period_code,
from CM_RSRC_DTL crd,
gmf_period_statuses gps,
CM_MTHD_MST cmm,
CR_RSRC_MST crm,
CM_CMPT_MST ccm
where gps.period_id = crd.PERIOD_ID 
and crd.cost_type_id = cmm.cost_type_id 
and crd.RESOURCES = crm.RESOURCES
and crm.COST_CMPNTCLS_ID = ccm.COST_CMPNTCLS_ID 
and gps.period_code in (:period1, :period2, :period3)
group by COST_CMPNTCLS_CODE, cmm.COST_MTHD_CODE, gps.period_code,NOMINAL_COST
order by 1,2,3,4


Previous Topic: Views in physica layer
Next Topic: call report xml publisher from oracle forms
Goto Forum:
  


Current Time: Thu Mar 28 18:21:54 CDT 2024