locked
CRM 2015 Online - FetchXml - Report prefiltering on linked entity and grouping RRS feed

  • Question

  • 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


    • Edited by wikky2007 Thursday, August 6, 2015 7:14 PM more detail
    Thursday, August 6, 2015 7:13 PM