Load xml data in report

[EgoSum]

Does anybody can explain in steps how can I load xml data in report and open it in reportViewer?


There's a short xml example ProductSales.xml:

<?xml version="1.0" standalone="yes"?>
<DocumentElement>
<ProductSales>
<Category>Accessory</Category>
<SubCategory>Bike Racks</SubCategory>
<Product>Hitch rack - 4 bike</Product>
<Sales>243696.0000</Sales>
</ProductSales>
<ProductSales>
<Category>Component</Category>
<SubCategory>Wheel</SubCategory>
<Product>ML Road Rear Wheel</Product>
<Sales>13042.2336</Sales>
</ProductSales>
</DocumentElement>


I try on this way, but report is open without data.

1. Add ProductSalesDataSet.xsd file in project
2. Create ProductSales DataTable in ProductSalesDataSet.xsd
3. Create report Report1.rdlc
4. Create reportViewer1 in Form1 and choose Report1.rdlc
5. Add in Form1_Load event: ProductSalesDataSet.ReadXml("ProductSales.xml");
6. Place ProductSales.xml in debug file

[joerozario]

use dataset.readxml(filename)

the xml file data will be uploaded in dataset.

then using scehma file create all the table which are in data set

use this scehma in report file connection

thank u