Help with Report Query

[joannem]

Hello,

I am having some difficulty in getting my report query set up so that I can access the data the way I want to.  I am using an xml file and selecting Xpath for my Query Language.

My xml file is in the following format

 

<smartxml>

     <lang>

           <labels>

          </labels>

     </lang>

    <repdata>

           <invcd>1234</invcd>

           <whs>abc</whs>

           <uom>each</uom>

           <serlot>

                   <lotcd>t12</lotcd>

                   <onhand>20</onhand>

           </serlot>

           <serlot>

                   <lotcd>t22</lotcd>

                   <onhand>50</onhand>

            </serlot>

    </repdata>

    <repdata>

             <invcd>1234</invcd>

             <whs>zxy</whs>

            <uom>each</uom>

             <serlot>

                       <lotcd>bb3</lotcd>

                      <onhand>10</onhand>

              </serlot>

       </repdata>

</smartxml>

 

So if I put in the query    /smartxml/repdata    then I am able to get the following

      Invcd       

      1234

            Whs            UOM 

             abc             each

                  Lot              On Hand

                   t12               20

             Whs            UOM

             zxy               each

                   Lot             On Hand

                  bb3               10

This is not correct because when there is more then one serlot tag within the repdata tags then I only get the first occurance.

If I put the query  to   /smartxml/repdata/serlot    I then get all occurances of the serlot within the repdata tags but I'm trying to group by Invcd and Whs and it disregards any grouping within the repdata tags.

I really hope this makes sense to someone as I am not sure how to resolve getting what I see above but under the first occurance of the lot where there is   t12 (lot) and   20 (onhand)     there should also be t22 (lot)  and 50 (onhand)

Any assistance would be greatly appreciated!