Hi,
I would hope someone can point me into the right direction doing this.
It
has been 5 hours and I still haven't figured out how to do this.
My xml is similar to this:
<persons>
<group>A</group>
<person>
<name>Bob</name>
<amount>10.00</amount>
<date>05/13/2003</date>
<paymentType>CASH</paymentType>
</person>
<person>
<name>Ada</name>
<amount>20.00</amount>
<date>05/10/2003</date>
<paymentType>DEBIT CARD</paymentType>
</person>
<person>
<name>David</name>
<amount>15.00</amount>
<date>05/13/2003</date>
<paymentType>CASH</paymentType>
</person>
<person>
<name>Kenny</name>
<amount>20.00</amount>
<date>05/13/2003</date>
<paymentType>CHEQUE</paymentType>
</person>
</persons>
<persons>
<group>B</group>
...
</persons>
I want an xsl which can produce something as follow:
05/10/2003
DEBIT CARD
Ada 20.00
TOTAL FOR DEBIT CARD 20.00(*)
TOTAL FOR 05/10/2003 20.00(*)
05/13/2003
CASH
Bob 10.00
David 15.00
TOTAL FOR CASH 25.00(*)
CHEQUE
Kenny 20.00
TOTAL FOR CHEQUE 20.00(*)
TOTAL FOR 05/13/2003 45.00(*)
TOTAL FOR GROUP A 65.00(*)
....
TOTAL FOR ALL GROUP sum of all group(*)
I have already got the grouping working correctly with a solution derived
from:
http://www.dpawson.co.uk/xsl/sect2/N4486.html#d4085e391
However, I can't get the TOTAL working.
Can someone please share some light on how I can get the total (the one with
(*)) using XSLT?
Any help would be appreciated. Thank you.
Kelvin
---
Outgoing mail is certified Virus Free.
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.478 / Virus Database: 275 - Release Date: 5/6/2003
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list