Group XML data on BI Publisher
I am working on a project on Oracle BI Publisher 10g, with XML data coming from XML files and format to display dashboards.
I am newbie on XSL-FO, XPATH and XSLT language, so I did a lot of search on net, but unsucessfully so if somebody could help, that would be great.
Here is my XML input file
[CODE]
<?xml version="1.0" encoding="UTF-8"?>
<ListOfBipMylFrAccountOrders>
 <Account>
  <AccountName>Compte1</AccountName>
   <ListOfInvoices>
    <Invoice>
     <InvoiceId>Facture 1</InvoiceId>
     <InvoiceDetails>
     <InvoiceLineDetail>
      <ProductID>Product1</ProductID>
      <Amount>100</Amount>
     </InvoiceLineDetail>
     <InvoiceLineDetail>
     <ProductID>Product2</ProductID>
     <Amount>100</Amount>
    </InvoiceLineDetail>
    </InvoiceDetails>  
  </Invoice>
  <Invoice>
     <InvoiceId>Facture 2</InvoiceId>
     <InvoiceLineDetail>
      <ProductID>Product1</ProductID>
      <Amount>100</Amount>