Hi all,
Please suggest us.
My xml file is
<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="Y:\02-Thomson\Users\A PT\xsl\vinoth-new.xsl"?>
<report>
<production>
<dept></dept>
<etype>Break</etype>
<user>thiyagu </user>
<date>2/5/2008</date>
<book>Traning </book>
<file>Programmi ng</file>
<status>WIP</status>
<task>RND</task>
<starttime>11:2 4:23 PM</starttime>
<endtime>11:46: 21 PM</endtime>
<totaltime> 22</totaltime>
<updateto/>
<comment>Tea Break</comment>
</production>
<production>
<etype>job</etype>
<user>thiyagu </user>
<date>2/5/2008</date>
<book>Traning </book>
<file>Programmi ng</file>
<status>WIP</status>
<task>RND</task>
<starttime>11:2 4:23 PM</starttime>
<endtime>11:46: 21 PM</endtime>
<totaltime> 22</totaltime>
<updateto/>
<comment>XML QC</comment>
</production>
<production>
<etype>Break</etype>
<user>thiyagu </user>
<date>3/5/2008</date>
<book>Traning </book>
<file>Programmi ng</file>
<status>WIP</status>
<task>RND</task>
<starttime>11:2 4:23 PM</starttime>
<endtime>11:46: 21 PM</endtime>
<totaltime> 22</totaltime>
<updateto/>
<comment>Tea Break</comment>
</production>
<production>
<etype>Job</etype>
<user>thiyagu </user>
<date>3/5/2008</date>
<book>Traning </book>
<file>Programmi ng</file>
<status>WIP</status>
<task>RND</task>
<starttime>11:2 4:23 PM</starttime>
<endtime>11:46: 21 PM</endtime>
<totaltime> 22</totaltime>
<updateto/>
<comment>XMl QC</comment>
</production>
</report>
I want the sum of the total time of the user based by date.
Advance thanks for ur help
Please suggest us.
My xml file is
<?xml version="1.0" encoding="UTF-8"?>
<?xml-stylesheet type="text/xsl" href="Y:\02-Thomson\Users\A PT\xsl\vinoth-new.xsl"?>
<report>
<production>
<dept></dept>
<etype>Break</etype>
<user>thiyagu </user>
<date>2/5/2008</date>
<book>Traning </book>
<file>Programmi ng</file>
<status>WIP</status>
<task>RND</task>
<starttime>11:2 4:23 PM</starttime>
<endtime>11:46: 21 PM</endtime>
<totaltime> 22</totaltime>
<updateto/>
<comment>Tea Break</comment>
</production>
<production>
<etype>job</etype>
<user>thiyagu </user>
<date>2/5/2008</date>
<book>Traning </book>
<file>Programmi ng</file>
<status>WIP</status>
<task>RND</task>
<starttime>11:2 4:23 PM</starttime>
<endtime>11:46: 21 PM</endtime>
<totaltime> 22</totaltime>
<updateto/>
<comment>XML QC</comment>
</production>
<production>
<etype>Break</etype>
<user>thiyagu </user>
<date>3/5/2008</date>
<book>Traning </book>
<file>Programmi ng</file>
<status>WIP</status>
<task>RND</task>
<starttime>11:2 4:23 PM</starttime>
<endtime>11:46: 21 PM</endtime>
<totaltime> 22</totaltime>
<updateto/>
<comment>Tea Break</comment>
</production>
<production>
<etype>Job</etype>
<user>thiyagu </user>
<date>3/5/2008</date>
<book>Traning </book>
<file>Programmi ng</file>
<status>WIP</status>
<task>RND</task>
<starttime>11:2 4:23 PM</starttime>
<endtime>11:46: 21 PM</endtime>
<totaltime> 22</totaltime>
<updateto/>
<comment>XMl QC</comment>
</production>
</report>
I want the sum of the total time of the user based by date.
Advance thanks for ur help
Comment