Dynamics Community Forum Thread Details

FetchXML Reporting Issue/Question | Attributes not Appearing on Report

I have constructed a FetchXML query which contains all of my required attributes for a report. However, when previewing the report in Visual Studio, some of the values just don't appear.

Here is the FetchXML query (used FetchXMLBuilder in XRMToolBox to build):

<fetch>
  <entity name="xrm_products" >
    <attribute name="xrm_productnumber" />
    <attribute name="xrm_name" />
    <attribute name="xrm_unitofmeasure" />
    <attribute name="xrm_price_base" />
    <attribute name="xrm_pricetype" />
    <link-entity name="xrm_agreement" from="xrm_agreementid" to="xrm_agreement" link-type="inner" >
      <attribute name="xrm_name" />
      <attribute name="xrm_start" />
      <attribute name="xrm_end" />
      <filter>
        <condition attribute="statuscode" operator="eq" value="163650000" />
      </filter>
      <link-entity name="xrm_testaccounts" from="xrm_testaccountsid" to="xrm_account" link-type="inner" >
        <attribute name="xrm_name" />
        <attribute name="xrm_fulladdress" />
      </link-entity>
      <link-entity name="xrm_rep" from="xrm_repid" to="xrm_rep" link-type="inner" >
        <attribute name="xrm_name" />
      </link-entity>
    </link-entity>
  </entity>
</fetch>

The fetch query displays all results accurately: