In this sample file (attached as IATI.rdl), you could find how to:
- Read master data from IATI (in that case: http://iatistandard.org/downloads/iaticodes_en_standard.xml)
- Use that master data as a parameter to load DFID Activities as a table
In order to run the report, you need either to save it on a MS Report Server, OR to install MS Report Builder (free and bundled with Sql Server Express Edition from Microsoft web site: http://www.microsoft.com/express/Database/InstallOptions.aspx)
I will try (soon) to video capture how to build it and post it as well.
Got this working, but needed to changes Data Source in the report.
Master data has been shifted from -
Suspect this means the old set of codes will no longer be maintained and their use is deprecated. In which case this report should probably be modified so that it can use the new codes in the new XML code format at -