Grouping not working when using Excel template
So I have made similar reports using Excel templates and never had this issue and I am failing to pinpoint where the problem is..
I am repeating data for every <Sales_Order_and_History_Uniion_S1> and am grouping the data for <TransactionOriginator_ID57> and this is what it contains:
<Sales_Order_and_History_Uniion_S1>
<PageHeaderNumber>1</PageHeaderNumber>
<CostCenter_ID1> 10</CostCenter_ID1>
<DocumentOrderInvoiceE_ID7>2645442135</DocumentOrderInvoiceE_ID7>
<LineNumber_ID10>7.000</LineNumber_ID10>
<Identifier2ndItem_ID16>ABCI600WC</Identifier2ndItem_ID16>
<DescriptionLine1_ID19>IN Digital 7-Day Astro Timer 2</DescriptionLine1_ID19>
<PrimaryLastVendorNo_ID22>1638</PrimaryLastVendorNo_ID22>
<AmountUnitCost_ID37>31.4253</AmountUnitCost_ID37>
<AmountExtendedPrice_ID39>35.00</AmountExtendedPrice_ID39>
<UnitsTransactionQty_ID67>2</UnitsTransactionQty_ID67>