Sign in
Microsoft.com
 
Microsoft
 
 
 

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

 > 

  • Question

  • Question
    Sign in to vote
    0
    Sign in to vote

    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