SSRS - Reviewing The XML Name For A Column

If you dont see any data being populated in your SSRS column, chances are that the column name is appearing in the XML slightly differently to how its been named in the SSRS report.

Eg. AM Column named 'Nav %' would need to be named in the SSRS report as 'Nav__Percent_'

How to view the XML names:

1. Jump onto the Dev box (eg. projmansrv06.dev)
2. Open the web browser:
http://localhost/ReportingWebService/Service.asmx
3. Select GenerateDataSetFull
4. sqlViewObjectId = 101 (template/report no.)
5. parameters: (empty)
6. trimDataSet: false
7. Then press [Invoke]