locked
Fetch XML filter condition 'Under' in SSRS report RRS feed

  • Question

  • Hi All,

    I am using the 'Under' operator in CRM 2016 Fetch based SSRS report. I get message Error: Sub report could not be shown.

    Is it that Under cant be used for SSRS reports?

    My query works fine from within VS and  gives me no error but when uploaded to CRM it is a problem, unless the condition Under is removed.

    <fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" count="10">
      <entity name="opportunity">
        <attribute name="opportunityid" />
        <attribute name="name" />
        <attribute name="estimatedvalue_base" />
        <attribute name="statuscode" alias="StatusCode"/>
        <attribute name="statecode" />
        <order attribute="estimatedvalue_base" descending="true" />
        <link-entity name="account" from="accountid" to="mays_client" alias="aa" link-type="inner">
          <filter type="and">
            <condition attribute="accountid" operator="under" uitype="account" value="@CRM_CustomerID" />
          </filter>
        </link-entity>	
         <filter type="and">
          <condition attribute="statecode" operator="eq" value="0" />
          <condition attribute="statuscode" operator="ne" value="3" />
          <condition attribute="statuscode" operator="not-null"/>
        </filter>
      </entity>
    </fetch>

    Any suggestions would be very grateful.

    Thanks

    Friday, January 13, 2017 5:46 PM