Need to regroup data in BI publisher
Hi
I have xml as below
<?xml version="1.0" encoding="UTF-8"?><ListOfBipPaymentReceiptReport
Account_QueryString="'Account'.Search="[FieldName] = 'ABC'""
><Account
><Id
>1-23T3</Id
><Created
>08/05/2015 07:52:38</Created
><CreatedBy
>1-23NS</CreatedBy
><AccountCreated
>08/05/2015 07:52:38</AccountCreated
><AccountCreatedBy
>EBIDPAL</AccountCreatedBy
><ListOfSiaPayment
><SiaPayment
><Id
>1-M0ODQ</Id
><Created
>12/21/2015 09:01:05</Created
><CreatedBy
>1-56CG1</CreatedBy
><AccountName
>Account Name Updated Again</AccountName
><CBiO2CustomerSequenceNumber
>1-23T3</CBiO2CustomerSequenceNumber
><CBiO2InvoiceAmount
>1000</CBiO2InvoiceAmount
><CBiO2MSISDN
>9836336003</CBiO2MSISDN
><CBiO2PaymentType
>Visa</CBiO2PaymentType
><CBiO2ReceiptNo
>5</CBiO2ReceiptNo
><CreatedByName
>ENANPRI</CreatedByName
><PaymentAmount
>235</PaymentAmount
><PaymentDate
>12/21/2015</PaymentDate
><PaymentMethod
>Credit Card</PaymentMethod
><PaymentNumber
>1-36983150</PaymentNumber
><PaymentType
>Visa</PaymentType
><CBiO2DepositAmount
>100</CBiO2DepositAmount