Hi All,
I have posted this after a bit of research and being new to XSLT.
There were similar clarifications in the past(FAQ) that helped me to move
however I would appreciate if any one can suggest me if I am heading in the
right direction.
1. Here is the XML sampple
<Contribution>
<AccountID>100</AccountID>
<AccountIDPub>173</AccountIDPub>
<EmployeeSurname>XXXX</EmployeeSurname>
<EmployeeFirstName>Sharon</EmployeeFirstName>
<EmployeeDOB>07/12/1955</EmployeeDOB>
<DateLastPaidTo>02/01/2009</DateLastPaidTo>
<ContributionType>Comp Emp</ContributionType>
<ContributionAmount>400.0</ContributionAmount>
</Contribution>
<Contribution>
<AccountID>100</AccountID>
<AccountIDPub>173</AccountIDPub>
<EmployeeSurname>XXXX</EmployeeSurname>
<EmployeeFirstName>Sharon</EmployeeFirstName>
<EmployeeDOB>07/12/1955</EmployeeDOB>
<DateLastPaidTo>02/01/2009</DateLastPaidTo>
<ContributionType>Personal</ContributionType>
<ContributionAmount>200.0</ContributionAmount>
</Contribution>
2. Key is <AccountIDPub> in the above nodes
3. The <ContributionType> can have 5 variations value(1,2,3,4,5)
The XML shows only 2 <ContributionType> it can have uptil 5.
The other I set them 0 for display (please see below)
The XSL I have written at the moment displays this as follows
AcNo. Name DOB Comp Emp Volu Salary Personal Spouse Total
------------------------------------------------------------------------
173 Sharon 07/12/1955 400.0 0 0 0 0 400.0
173 Sharon 07/12/1955 0 0 0 200.0 0 200.0
What would be the ideal way to get an output in a single row?
(Including adding the total)
AcNo. Name DOB Comp Emp Volu Salary Personal Spouse Total
-------------------------------------------------------------------------
173 Sharon 07/12/1962 400.0 0 0 200.0 0 600.0
1. Should this be merged into a single XML first and then displayed in
a loop I guess I might need to do this in 2 passes...?
I understand that I can use a key (AcNo) and iterate, wasn't sure if there were
cleaner approach.
Any pointers appreciated....
Regards
Sunder
Make Yahoo!7 your homepage and win a trip to the Quiksilver Pro. Find out
more
--~------------------------------------------------------------------
XSL-List info and archive: http://www.mulberrytech.com/xsl/xsl-list
To unsubscribe, go to: http://lists.mulberrytech.com/xsl-list/
or e-mail: <mailto:xsl-list-unsubscribe(_at_)lists(_dot_)mulberrytech(_dot_)com>
--~--