Using an XML feed as a datasource

In the previous recipe, the entire data for the report was hardcoded. In this recipe, we will continue to use the data table as a datasource, but the data for this report will come through an XML feed. The XML is retrieved at runtime, and parsed and filled in a data table, which is then rendered in the report.

Getting ready

This recipe requires the machine on which you work to be connected to the Internet. The XML feed (http://themoneyconverter.com/rss-feed/USD/rss.xml) used in this report is downloaded at runtime.

How to do it…

1. In the existing project, PKTExchRateReports, add a new report called PKTExchRateFromWeb.

2. Add a new data method and double-click on it to create the business logic.

3. Replace the empty method with the logic given here:

   [DataMethod(), PermissionSet(SecurityAction.Assert, Name = "FullTrust")]
   Public static DataTableExchangeRateData()
       {
   DataTable dt;
   
   dt = new DataTable();
   dt.Columns.Add("Category", typeof(string));
   dt.Columns.Add("Base Currency...