All,
I have created a custom FetchXml report which I need to run on a linked entity (meaning the results are actually a different entity). I followed these instructions:
https://technet.microsoft.com/en-us/library/Dn531099.aspx#Fetch_basedPre_filtering
Here is the linked entity line from my FetchXml:
<link-entity name="batch" from="batchid" to="batchid" visible="false" link-type="outer" alias="batch___" enableprefiltering="1" prefilterparametername="CRM_FilteredBatch">
<attribute name="date" alias="date" />
</link-entity>
The report runs ok, but two things are wrong:
1. The report is not filtering on the linked entity record (it is actually returning two records for some reason).
2. None of the groupings that I have in place are being applied (my guess is because two records are being returned).
Has anyone run into this? Why would the prefiltering not work? Any help is appreciated. Thanks