How to create a chart with XMLDatasource

[vivek.umredkar]

Hi,

I have a requirement where I need to show a report with table and chart from XML data source.

I have created Data Adapter with XML datasource. For displaying table I am giving XPath (/report/tableRows/tableRow) and fields shown are used. 

Table is getting displayed properly. For chart I have created new dataset with new Xpath(/report/chartRows/chartRow)  and I am using fields for plotting chart.

But chart is coming blank.

Sample XML - 

<?xml version="1.0" encoding="UTF-8"?>

<report>

      <chartRows>

               <chartRow>

                    <Col1>Red</Col1>

                    <Col2>10</Col2>

              </chartRow>

              <chartRow>

                   <Col1>Green</Col1>

                   <Col2>20</Col2>

              </chartRow>

     </chartRows>

    <tableRows>

             <tableRow>

                   <Column1>10</Column1>

                   <Column2>Red</Column2>

             </tableRow>

             <tableRow>

                   <Column1>20</Column1>

                   <Column2>Green</Column2>

             </tableRow>

    </tableRows>

</report>

Please suggest.

Thanks

Vivek