title: SSRS report - Display 1 to Many relationships
body: <p>I am trying to build a custom SSRS report and publish to our CRM system. I have a Dataset created using FetchXml by connecting to Microsoft Dynamics CRM 365. The data set has 1 to Many and Many to Many relationships. The query looks fine and I am able to preview the Dataset results in Visual Studio. I am able to display the primary entity fields in the report but failed to show the 1 to Many relationship values. Please suggest on how to get this wprking. My fetch xml looks like this</p>
  
  <pre><code>&lt;?xml version="1.0" encoding="UTF-8"?&gt;
  &lt;fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false"&gt;
     &lt;entity name="entity1"&gt;
        &lt;attribute name="name"/&gt;
        &lt;link-entity name="entity2" from="entity2id" to="entity1id"&gt;
           &lt;attribute name="name"/&gt;
        &lt;/link-entity&gt;
     &lt;/entity&gt;
  &lt;/fetch&gt;
  </code></pre>