Dear Friends,
My xml file is some thing like this
* xml file is generated using
JSP)so the contents of the xml are not static.xml is generated everytime depending upon the user criteria.I want to present the data in xml as a Report using xsl.
<ROW>
<ID>1</ID>
<DID>4444</DID>
<DATE>2/1/2000</DATE>
<TIME> 8:23PM</TIME>
<SOURCE_NO>668788</SOURCE_NO>
<DESTINATION_NO>6566462</DESTINATION_NO>
<DESTINATION_COUNTRY>Pakistan</DESTINATION_COUNTRY>
<DURATION>6</DURATION>
<CALL_CHARGES>1.65</CALL_CHARGES>
</ROW>
<ROW>
<ID>2</ID>
<DID>4444</DID>
<DATE>2/1/2000</DATE>
<TIME> 9:12PM</TIME>
<SOURCE_NO>76878</SOURCE_NO>
<DESTINATION_NO>687878</DESTINATION_NO>
<DESTINATION_COUNTRY>Pakistan</DESTINATION_COUNTRY>
<DURATION>10</DURATION>
<CALL_CHARGES>2.8</CALL_CHARGES>
</ROW>
<ROW>
<ID>3</ID>
<DID>4444</DID>
<DATE>3/1/2000</DATE>
<TIME> 5:05AM</TIME>
<SOURCE_NO>6877</SOURCE_NO>
<DESTINATION_NO>87787</DESTINATION_NO>
<DESTINATION_COUNTRY>Sri Lanka</DESTINATION_COUNTRY>
<DURATION>12</DURATION>
<CALL_CHARGES>1.2</CALL_CHARGES>
</ROW>
<ROW>
<ID>4</ID>
<DID>5555</DID>
<DATE>1/1/2000</DATE>
<TIME> 9:23AM</TIME>
<SOURCE_NO>422135</SOURCE_NO>
<DESTINATION_NO>6566462</DESTINATION_NO>
<DESTINATION_COUNTRY>india</DESTINATION_COUNTRY>
<DURATION>2</DURATION>
<CALL_CHARGES>0.36</CALL_CHARGES>
</ROW>
<ROW>
<ID>5</ID>
<DID>5555<DID>
<DATE>1/1/2000</DATE>
<TIME>10:10AM</TIME>
<SOURCE_NO>6566462</SOURCE_NO>
<DESTINATION_NO>6566543</DESTINATION_NO>
<DESTINATION_COUNTRY>india</DESTINATION_COUNTRY>
<DURATION>3</DURATION>
<CALL_CHARGES>0.87</CALL_CHARGES>
</ROW>
Main thing to note is that <DID></DID> tag has repeated values eg for first 3 rows it is "4444" then for the next 2 row it is "5555"
What i want to achieve is to present the data in xml file in a way such that when i apply processing to rows then DID should be displayed once then the data contained in rows for that DID then next DID...some thing like this...
DID: 4444
Date Time Org.No Ter.No. Country Dur. Chrgs
2/1/2000 8:23PM 668788 6566462 Pakistan 6 1.65
2/1/2000 9:12PM 76878 687878 Pakistan 10 2.8
3/1/2000 5:05AM 6877 87787 Sri Lanka 12 1.2
DID: 5555
1/1/2000 9:23AM 422135 6566462 india 2 0.36
1/1/2000 10:10AM 6566462 6566543 india 3 0.87
is this possible using xsl?
I THANK Any answer or help in advance.
Regards,
Pankaj