Hi, I'm quite new to XSLT....
I have an XML file structured as follows:
<range>
<group label="FILE_NO" level="_1" value="1020313">
<row>
<field label="FILE_NO" name="FILE_NO" >1020313</field>
<field label="CHARGE" name="CHARGE">fee 1</field>
<field label="AMT" name="AMT">100</field>
</row>
<row>
<field label="FILE_NO" name="FILE_NO" >1020313</field>
<field label="CHARGE" name="CHARGE">fee 1</field>
<field label="AMT" name="AMT">25</field>
</row>
<row>
<field label="FILE_NO" name="FILE_NO" >1020313</field>
<field label="CHARGE" name="CHARGE">fee 2</field>
<field label="AMT" name="AMT">100</field>
</row>
<row>
<field label="FILE_NO" name="FILE_NO" >1020313</field>
<field label="CHARGE" name="CHARGE">fee 3</field>
<field label="AMT" name="AMT">25</field>
</row>
<row>
<field label="FILE_NO" name="FILE_NO" >1020313</field>
<field label="CHARGE" name="CHARGE">fee 4</field>
<field label="AMT" name="AMT">25</field>
</row>
....
</group>
<group label="FILE_NO" level="_2" value="1020314">
....similar as above....
</group>
</range>
How can I write a recursive XLST template that will display data as follows:
file fee1 fee2 fee3+fee4
1020313 125 125 ....
1020314 ... ... ....
Basically totalling up each fee in its own column and/or computing the totals for groups of fees?
Can anyone just help me get started?
Any help is greatly appreciated.
__PC
I have an XML file structured as follows:
<range>
<group label="FILE_NO" level="_1" value="1020313">
<row>
<field label="FILE_NO" name="FILE_NO" >1020313</field>
<field label="CHARGE" name="CHARGE">fee 1</field>
<field label="AMT" name="AMT">100</field>
</row>
<row>
<field label="FILE_NO" name="FILE_NO" >1020313</field>
<field label="CHARGE" name="CHARGE">fee 1</field>
<field label="AMT" name="AMT">25</field>
</row>
<row>
<field label="FILE_NO" name="FILE_NO" >1020313</field>
<field label="CHARGE" name="CHARGE">fee 2</field>
<field label="AMT" name="AMT">100</field>
</row>
<row>
<field label="FILE_NO" name="FILE_NO" >1020313</field>
<field label="CHARGE" name="CHARGE">fee 3</field>
<field label="AMT" name="AMT">25</field>
</row>
<row>
<field label="FILE_NO" name="FILE_NO" >1020313</field>
<field label="CHARGE" name="CHARGE">fee 4</field>
<field label="AMT" name="AMT">25</field>
</row>
....
</group>
<group label="FILE_NO" level="_2" value="1020314">
....similar as above....
</group>
</range>
How can I write a recursive XLST template that will display data as follows:
file fee1 fee2 fee3+fee4
1020313 125 125 ....
1020314 ... ... ....
Basically totalling up each fee in its own column and/or computing the totals for groups of fees?
Can anyone just help me get started?
Any help is greatly appreciated.
__PC