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>