XML Maps in Excel

I have created a XML report (Code below). However, if I want to map it to Excel using XML maps, it only displays headings without data as in the figure below. I would like to display the data as well.

Here is my Excel report below as follows from SQL server:

<Reports>
  <Report>
    <Warehouse>E</Warehouse>
    <Warehousename>Eastern Warehouse</Warehousename>
    <QtyOnHand>159082.00</QtyOnHand>
    <costValueOnhand>2791664.52</costValueOnhand>
    <sellingValueOnHand>4213403.59</sellingValueOnHand>
  </Report>
  <Report>
    <Warehouse>FG</Warehouse>
    <Warehousename>Finished Goods Warehouse</Warehousename>
    <QtyOnHand>12127.00</QtyOnHand>
    <costValueOnhand>220402.80</costValueOnhand>
    <sellingValueOnHand>289048.80</sellingValueOnHand>
  </Report>
  <Report>
    <Warehouse>FS</Warehouse>
    <Warehousename>Floor Stock Warehouse</Warehousename>
    <QtyOnHand>184.40</QtyOnHand>
    <costValueOnhand>829.80</costValueOnhand>
    <sellingValueOnHand>1327.68</sellingValueOnHand>
  </Report>
  <Report>
    <Warehouse>N</Warehouse>
    <Warehousename>Northern Warehouse</Warehousename>
    <QtyOnHand>271926.50</QtyOnHand>
    <costValueOnhand>2920831.41</costValueOnhand>
    <sellingValueOnHand>4677236.75</sellingValueOnHand>
  </Report>
  <Report>
    <Warehouse>R</Warehouse>
    <Warehousename>Returnable Items</Warehousename>
    <QtyOnHand>2000.00</QtyOnHand>
    <costValueOnhand>25500.00</costValueOnhand>
    <sellingValueOnHand>32500.00</sellingValueOnHand>
  </Report>
  <Report>
    <Warehouse>RM</Warehouse>
    <Warehousename>Raw Materials Warehouse</Warehousename>
    <QtyOnHand>12043.00</QtyOnHand>
    <costValueOnhand>359927.88</costValueOnhand>
    <sellingValueOnHand>573234.70</sellingValueOnHand>
  </Report>
  <Report>
    <Warehouse>S</Warehouse>
    <Warehousename>Southern Warehouse</Warehousename>
    <QtyOnHand>116627.00</QtyOnHand>
    <costValueOnhand>2378373.00</costValueOnhand>
    <sellingValueOnHand>3597947.42</sellingValueOnHand>
  </Report>
  <Report>
    <Warehouse>SA</Warehouse>
    <Warehousename>Subassembly Warehouse</Warehousename>
    <QtyOnHand>1000.00</QtyOnHand>
    <costValueOnhand>573515.28</costValueOnhand>
    <sellingValueOnHand>902771.00</sellingValueOnHand>
  </Report>
  <Report>
    <Warehouse>SP</Warehouse>
    <Warehousename>Specials for Product Config.</Warehousename>
    <QtyOnHand>27784.00</QtyOnHand>
    <costValueOnhand>37400.11</costValueOnhand>
    <sellingValueOnHand>107639.40</sellingValueOnHand>
  </Report>
  <Report>
    <Warehouse>SW</Warehouse>
    <Warehousename>South West Warehouse</Warehousename>
    <QtyOnHand>4847.00</QtyOnHand>
    <costValueOnhand>1551040.00</costValueOnhand>
    <sellingValueOnHand>2714320.00</sellingValueOnHand>
  </Report>
</Reports>