FetchXML Field Types in SSRS

  • Posted on: 15 May 2014
  • By: feridun

When creating reports that use FetchXML, some field types are returned with two fields, the name of the field and the name of the field with Value appended, fieldValue.

The table shows the field types that I found that have a Value version. Other CRM field types only return one field and are of type String.

FetchXML Notes

  • Posted on: 29 May 2013
  • By: feridun

Link Entities

When retrieving attributes from linked entities it seems that attributes must have an alias otherwise you can't refer to them: