xml publisher with matrix report

Coding :

<?for-each-group:/XXMTZ_NSG_PO_ITEM_QTY_DET/LIST_G_BUYER_/G_BUYER_;SUPPLIER_?>

<?SUPPLIER_?><?variable@incontext:G11;current-group()?>

Row to column :


<?for-each-group@column:/XXMTZ_NSG_PO_ITEM_QTY_DET/LIST_G_BUYER_/G_BUYER_;./PO_CREATION_MONTH?><?./PO_CREATION_MONTH?><?end for-each-group?>

<?for-each-group:/XXMTZ_NSG_PO_ITEM_QTY_DET/LIST_G_BUYER_/G_BUYER_;./SUPPLIER_SITE_?> <?variable@incontext:G1;current-group()?><?./SUPPLIER_SITE_?>

<?for-each-group:/XXMTZ_NSG_PO_ITEM_QTY_DET/LIST_G_BUYER_/G_BUYER_;./ITEM_?> <?variable@incontext:G1;current-group()?><?./ITEM_?>

<?for-each-group:/XXMTZ_NSG_PO_ITEM_QTY_DET/LIST_G_BUYER_/G_BUYER_;./DESCRIPTION?> <?variable@incontext:G1;current-group()?><?./DESCRIPTION?>

 
full coding:


XML

<?xml version="1.0"?>

<!-- Generated by Oracle Reports version 6.0.8.27.0 -->
-<SIFYLEASEMASTER> <LIST_G_LEASE_NUMBER> </LIST_G_LEASE_NUMBER> <LIST_G_LEASE_PAYMENT> </LIST_G_LEASE_PAYMENT> -<LIST_G_ROW_ID> -<G_ROW_ID> <ROW_ID>AABCoZAGPAAB9y1AAd</ROW_ID> <LEASE_NUMBER2>ARR/TECH/TOWER</LEASE_NUMBER2> <PAYMENT_AMOUNT>4000</PAYMENT_AMOUNT> <PAY_MON>01-JAN-10</PAY_MON> <LESSOR_NAME>A HAJA MAIDEEN</LESSOR_NAME> </G_ROW_ID> -<G_ROW_ID> <ROW_ID>AABCoZAGPAAB9y1AAe</ROW_ID> <LEASE_NUMBER2>ARR/TECH/TOWER</LEASE_NUMBER2> <PAYMENT_AMOUNT>4000</PAYMENT_AMOUNT> <PAY_MON>01-FEB-10</PAY_MON> <LESSOR_NAME>A HAJA MAIDEEN</LESSOR_NAME> <LESSOR_NUM>27959</LESSOR_NUM> </G_ROW_ID> -<G_ROW_ID> <ROW_ID>AABCoZAGPAAB9y1AAf</ROW_ID> <LEASE_NUMBER2>ARR/TECH/TOWER</LEASE_NUMBER2> <PAYMENT_AMOUNT>4000</PAYMENT_AMOUNT> <PAY_MON>01-MAR-10</PAY_MON> <LESSOR_NAME>A HAJA MAIDEEN</LESSOR_NAME> </G_ROW_ID> -<G_ROW_ID> <ROW_ID>AABCoZAGPAAB9zwAAD</ROW_ID> <LEASE_NUMBER2>ARR/TECH/TOWER</LEASE_NUMBER2> <PAYMENT_AMOUNT>4000</PAYMENT_AMOUNT> <PAY_MON>01-MAR-10</PAY_MON> <LESSOR_NAME>sneh sanan</LESSOR_NAME> </G_ROW_ID> -<G_ROW_ID> <ROW_ID>AABCoZAAYAAA8BBAAp</ROW_ID> <LEASE_NUMBER2>ARR/ADM/OFF/1</LEASE_NUMBER2> <PAYMENT_AMOUNT>699938</PAYMENT_AMOUNT> <PAY_MON>01-JAN-10</PAY_MON> <LESSOR_NAME>NAGARJUN VALLURIPALLI</LESSOR_NAME> </G_ROW_ID> -<G_ROW_ID> <ROW_ID>AABCoZAAYAAA8BBAA3</ROW_ID> <LEASE_NUMBER2>ARR/ADM/OFF/2</LEASE_NUMBER2> <PAYMENT_AMOUNT>699938</PAYMENT_AMOUNT> <PAY_MON>01-JAN-10</PAY_MON> <LESSOR_NAME>NAGARJUN VALLURIPALLI</LESSOR_NAME> </G_ROW_ID> -<G_ROW_ID> <ROW_ID>AABCoZAAYAAA8BBAA4</ROW_ID> <LEASE_NUMBER2>ARR/ADM/OFF/2</LEASE_NUMBER2> <PAYMENT_AMOUNT>699938</PAYMENT_AMOUNT> <PAY_MON>01-FEB-10</PAY_MON> <LESSOR_NAME>NAGARJUN VALLURIPALLI</LESSOR_NAME> </G_ROW_ID> -<G_ROW_ID> <ROW_ID>AABCoZAAYAAA8BBAAq</ROW_ID> <LEASE_NUMBER2>ARR/ADM/OFF/1</LEASE_NUMBER2> <PAYMENT_AMOUNT>458580</PAYMENT_AMOUNT> <PAY_MON>01-FEB-10</PAY_MON> <LESSOR_NAME>NAGARJUN VALLURIPALLI</LESSOR_NAME> </G_ROW_ID> -<G_ROW_ID> <ROW_ID>AABCoZAAYAAA8BBAA5</ROW_ID> <LEASE_NUMBER2>ARR/ADM/OFF/2</LEASE_NUMBER2> <PAYMENT_AMOUNT>699938</PAYMENT_AMOUNT> <PAY_MON>01-MAR-10</PAY_MON> <LESSOR_NAME>NAGARJUN VALLURIPALLI</LESSOR_NAME> <LESSOR_NUM>20637</LESSOR_NUM> </G_ROW_ID> </LIST_G_ROW_ID> </SIFYLEASEMASTER>