reporting on xml. elementpath syntax

[pragaw]

Hello,

I have problems with reporting on xml data. I have a folder of xml documents. User picks a document from a list and I show that file in the report. One of the xml files:

<ns1:VEN_INVOICE_HDR xmlns:ns1="[URL unfurl="true"]http://www.mywebsite.com">[/URL]
--<ns1:EDI_PO_NO>37266</ns1:EDI_PO_NO> 
--<ns1:VENDOR_NAME>VendorA.</ns1:VENDOR_NAME> 
--<ns1:NET_DAYS>30</ns1:NET_DAYS> 
--<ns1:SHIP_DT>20070311</ns1:SHIP_DT> 
--<ns1:TERM_DAYS1>10</ns1:TERM_DAYS1> 
--<ns1:VENDOR_ID>4164672</ns1:VENDOR_ID> 
--<ns1:VENDOR_INV_NO>090757</ns1:VENDOR_INV_NO> 
--<ns1:DISCREPANCY_AMT>0</ns1:DISCREPANCY_AMT> 
-----<ns1:VEN_INVOICE_DTL>
-----<ns1:INVOICE_COST>37.83</ns1:INVOICE_COST> 
-----<ns1:INVOICE_QTY>120</ns1:INVOICE_QTY> 
-----<ns1:PACK_UM>CA</ns1:PACK_UM> 
-----<ns1:SEQ_NO>6</ns1:SEQ_NO> 
-----<ns1:ITEM_ID>00550000</ns1:ITEM_ID> 
-----<ns1:ITEM_TYPE>UA</ns1:ITEM_TYPE> 
-----<ns1:EXTENDED_AMT>4529.6</ns1:EXTENDED_AMT> 
---------<ns1:VEN_UNKNOWN_INVOICE_DEAL>
------------<ns1:DEAL_NO>A</ns1:DEAL_NO> 
------------<ns1:DEAL_TYPE_NAME>F180</ns1:DEAL_TYPE_NAME> 
------------<ns1:DEAL_AMOUNT>10</ns1:DEAL_AMOUNT> 
---------</ns1:VEN_UNKNOWN_INVOICE_DEAL>
---------<ns1:VEN_INVOICE_DEAL>
------------<ns1:DEAL_NO>A</ns1:DEAL_NO> 
------------<ns1:DEAL_TYPE_NAME>F180</ns1:DEAL_TYPE_NAME> 
------------<ns1:DEAL_AMOUNT>10</ns1:DEAL_AMOUNT> 
---------</ns1:VEN_INVOICE_DEAL>
-----</ns1:VEN_INVOICE_DTL>
--</ns1:VEN_INVOICE_HDR>

my query string:
<ElementPath>ns1:VEN_INVOICE_HDR{}/ns1:VEN_INVOICE_DTL/ns1:VEN_UNKNOWN_INVOICE_DEAL</ElementPath>

The question is how do I show all elements from the ns1:VEN_UNKNOWN_INVOICE_DEAL and ns1:VEN_INVOICE_DEAL?

So far I figured out how to show one or the other.

Can anybody help?

Thanks.