Having already created reports in SSRS that use FetchXML as the data source we began to investigate what we could create to leverage FetchXML as the data source for the new Word Document Templates. But what if you want to pull in data from other entities that do not have a direct relationship in your data model? Or better yet, what if you wanted to retrieve data from another external system? The user interface in CRM forces you to select a single starting entity and only entities that have a direct relationship for the data.
We were intrigued by this functionality and began to explore it immediately, but discovered one shortcoming. Dynamics CRM now allows you to create and persist Document Templates using Microsoft Word.
