sonny_j81
asked on
How to read xml data in crystal report
Dear Expert,
I wanna to retrieve xml data from one of the field in table.
May i know how to do that in crystal report?
how can i get the data in RegionCode field which is stored in xmldata field in table?
The XMLdata field store this kind of data :
<A><B><RegionCode>KL</Regi onCode></B ></A>
I wanna to retrieve xml data from one of the field in table.
May i know how to do that in crystal report?
how can i get the data in RegionCode field which is stored in xmldata field in table?
The XMLdata field store this kind of data :
<A><B><RegionCode>KL</Regi
Should work.
What version of Crystal?
Do you have the XML drivers installed?
mlmcc
What version of Crystal?
Do you have the XML drivers installed?
mlmcc
ASKER
my crystal report is version 11. how to know whether got install XML driver?
ASKER
My xmldata is stored in one column of table.I dun have XML file.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Database Expert, and CREATE NEW CONNECTION.
Choose XML connection and OK.
In the XML box....assign you datasource
MikeV