I'm really in seriour trouble, running way behind on a project and have tried everything, I think. I've got to create reports from data that's stored in a text field in XML. I get a recordset using ADO then I invoke the save method on the recordset to generate an XML file.

The problem is the is the file that is saved contains a number of fields from the same table as well as the fields from the text field; most of my data is in the text field and just gets strung together as one field.

I've tried authenicating the ADO XML file using XML Spy but it gives me error - unable to locate a reference to a support schema type within document.

This is the file generated by the ADO XML, you can see where Text starts all those fileds are what I want to be able to see in the reports but I can't get to them. I can only see Text as a single field. I've tried creating several schema files with XML Spy but none seem to work.

I'm also using Crystal 9 and have tried configuring the XML driver in Data Island, ADO XML, and Datat Direct modes.

Any help would really be appreciated, I'm in big trouble these should have been done days ago , it looked pretty simple on the surface, I'm out of things to try!!!

<xml xmlns:s='uuid:BDC6E3F0-6DA3-11d1-A2A3-00AA00C14882'
xmlns:dt='uuid:C2F41010-65B3-11d1-A29F-00AA00C14882'
xmlns:rs='urn:schemas-microsoft-com:rowset'
xmlns:z='#RowsetSchema'>
<s:Schema id='RowsetSchema'>
<s:ElementType name='row' content='eltOnly'>
<s:AttributeType name='Data_Machine_Id' rs:number='1' rs:nullable='true'>
<s:datatype dt:type='int' dt:maxLength='4' rs:precision='10' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='Sequence_Number' rs:number='2' rs:nullable='true'>
<s:datatype dt:type='int' dt:maxLength='4' rs:precision='10' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='Client_Id' rs:number='3' rs:nullable='true' rs:write='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='23'/>
</s:AttributeType>
<s:AttributeType name='Contact_Number' rs:number='4' rs:nullable='true' rs:write='true'>
<s:datatype dt:type='i2' dt:maxLength='2' rs:precision='5' rs:fixedlength='true'/>
</s:AttributeType>
<s:AttributeType name='Text' rs:number='5' rs:nullable='true' rs:maydefer='true' rs:write='true'>
<s:datatype dt:type='string' rs:dbtype='str' dt:maxLength='65500' rs:long='true'/>
</s:AttributeType>
<s:extends type='rs:rowbase'/>
</s:ElementType>
</s:Schema>
<rs:data>
<z:row Data_Machine_Id='1036934551' Sequence_Number='21242' Client_Id='020826025612475385043C' Contact_Number='1'
Text='<Row><DataMachineID>100797316</DataMachineID><SeqNum>8064</SeqNum><NoteHeader>Project Plan</NoteHeader><Contact>Shauna Butchereit</Contact><Company>CIBC - NaSCo - National Support &amp; Consulting</Company><User>BOLES</User><BusUnit></BusUnit><AppointmentDate>January 13, 2003</AppointmentDate><AppointmentTime>09:00 AM</AppointmentTime><AttendeesIDs></AttendeesIDs><CallType>Service Call</CallType><ProductsDiscussed></ProductsDiscussed><PromotionsDiscussed></PromotionsDiscussed><Conversation></Conversation><NextStep></NextStep><ApptID>100797316:8064</ApptID><HotlistIDs></HotlistIDs><IssueIDs></IssueIDs><OppID></OppID><OppNum></OppNum><OppDesc></OppDesc></Row>'/>
<z:row Data_Machine_Id='1036934551' Sequence_Number='28213' Client_Id='020424021472475385043C' Contact_Number='8'
Text='