>private oXML AS MSXML2.DOMdocument, cXMLline as String >oXML = createObject('MSXML2.DOMDocument') >oXML.loadXML(<your XML source>) > >report form myReport ... object myReportlistener && myReportlistener as myReportlistener - myReport uses m.cXMLline in detail band > >define class myReportlistener >PROCEDURE BeforeBand >LPARAMETERS nBandObjCode, nFRXRecNo >if nBandObjCode = 4 && Detail > cXMLline = cXMLline(m.nFRXRecNo) >endif >enddefine > >function cXMLline as String >lparameters nLine >local cResult as String, oNode as MSXML2.DOMDocument, iNode as Integer >cResult = '' >for each oNode as MSXML2.DOMDocument in m.oXML.Item(m.nLine) && not sure about this > cResult = m.cResult + m.oNode.nodeName + ': ' + m.oNode.nodeText + CRLF >endfor >>
>><Field> >> <Name>MyField1</Name> >> <OldValue>123</OldValue> >> <NewValue>3321</NewValue> >></Field> >><Field> >> <Name>MyField2</Name> >> <OldValue>ABC</OldValue> >> <NewValue>NBC</NewValue> >></Field> >>>>