I have an XML file containing data in the following form :
<sph:trade>
<sph:column sph:index="0" sph:name="Entity" sph:type="String">AVENIR PERFORMANCE</sph:column>
<sph:column sph:index="1" sph:name="Counterparty" sph:type="String">AL IJTIMAI SECURITE</sph:column>
<sph:column sph:index="2" sph:name="Instrument Reference" sph:type="String">200018</sph:column>
<sph:column sph:index="3" sph:name="Name" sph:type="String">BDT 010994 11</sph:column>
<sph:column sph:index="4" sph:name="Quantity" sph:type="Double">101,000000000000</sph:column>
<sph:column sph:index="5" sph:name="Gross Price" sph:type="Double">0,000000000000</sph:column>
<sph:column sph:index="6" sph:name="Trade Date" sph:type="Date">2010-08-20</sph:column>
<sph:column sph:index="7" sph:name="Infos" sph:type="String" />
</sph:trade>
By integring XML to Crystal reports, i get the following result :
name Column_text
Entity Avenir PERFORMANCE
Counterparty ALIJTIMAI SECURITY
......... ..........
Entity AL IJTIMAI SECURITY
Counterparty AL IJTIMAI SECURITY
......... ..........
My problem is : I want to get the following result :
Entity Counterparty Instrument
data data data
data data data
data data data
data data data
Thank you..