xml to xml???

[grimmersnee]

I have xml data stored in my SQL 2000 DB as text. I want to retrieve the data into a dataset to be used as a datasource for a crystal report. The problem: because the data is not contained in a xml file I cannot use the readxml method to properly populate the dataset. Upon reading the data from the database using ole and populating the dataset with the adapter, the adapter gets rid of all the tags and replaces tags with no data in them with with zero. My big problem is my crystal report is somewhat dynamic and is based on an xml schema (.xsd), so it is expecting data in an xml format. Hopefullt this all makes sense, can any help or offer any bright ideas?