SSRS - XML Configuration

There are 5 major parts to the config to setup.

1. Set the TemplateId (this is obtained from the AM Grids properties).
2. Set default params. Note there are no double quotes ("") used here. Semicolon (;) seperated.
3. Set the trimDataSet to false - this then returns the lowest level of detail.
4. The name of the report must be specified (as per AP demo). Any spaces must be replaced with the underline character ( _ ). Nb sometimes there is a space at the end of the report name in AM (easiest way to test is to run the report from the localhost webpage - this is described within this page)
5. Specify the column names to be returned. Again, any spaces should be replaced with underlines ( _ ). There are other oddities regarding column naming in XML, these are described below (such as % is written as _Percent_)