web services - Birt: Webservice returns xml string..how to map to columns? -

i using wsdl/webservice url connect data source. problem webservice returns xml string output. problem not able map proper fields/columns. sample returned xml string below

<?xml version="1.0" encoding="utf-8"?> <response><items><item><nv_id>1</nv_id><nv_id_parent>0</nv_id_parent><nv_label>satisfactory</nv_label></item><item><nv_id>2</nv_id><nv_id_parent>1</nv_id_parent><nv_label>niveau admin</nv_label></item><item><nv_id>3</nv_id><nv_id_parent>2</nv_id_parent><nv_label>enseigne</nv_label></item><item><nv_id>4</nv_id><nv_id_parent>3</nv_id_parent><nv_label>magasin</nv_label></item></items></response> 

i have found way parse xml , compute columns it. however, problem xml string returned single row first row of data extracted in computed column. how can fetch rows xml dataset?

i have used below code parse above xml , create column.

importpackage(packages.org.apache.xerces.parsers); importpackage(packages.org.xml.sax); importpackage(packages.java.io);  var parser = new domparser(); parser.parse(new inputsource(new stringreader(datasetrow["return"]))); var nodelist = parser.getdocument().getelementsbytagname('nv_label'); var entry = nodelist.item(0).getfirstchild().getnodevalue();  entry; 

now problem xml returned single row string. xml string contains lot of rows , fetch rows column. how can that?

p.s: not javascript or java or pojo or scripted data source please provide bit more detail if solution use of these

if use birt designer design data source connection first make wsdl data source endpoint http://wsf.cdyne.com/weatherws/weather.asmx?wsdl.

then create data set retrieve , structure data source. use data set wizard map xml schema columns.

you can open xml of report extract format or start making report data. there lot of values can set retrieve content want.