Report Design
 Crystal Reports Forum : Crystal Reports 9 through 2020 : Report Design
Message Icon Topic: XML & Crystal reports 2008 Post Reply Post New Topic
Author Message
sliparmax
Newbie
Newbie


Joined: 27 Oct 2010
Online Status: Offline
Posts: 1
Quote sliparmax Replybullet Topic: XML & Crystal reports 2008
    Posted: 27 Oct 2010 at 5:57am

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..
 
IP IP Logged
Post Reply Post New Topic
Printable version Printable version

Forum Jump
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot delete your posts in this forum
You cannot edit your posts in this forum
You cannot create polls in this forum
You cannot vote in polls in this forum



This page was generated in 0.031 seconds.