Dataset of Child Entity creation in SSRS for D365

 Dataset of Child Entity creation in SSRS for D365

Let's look at the example directly.

CrimeReport entity is the parent entity of Victims entity.

Now, I want to show all the victims under the specified CrimeReport record.

So,  need to create a dataset for the victims. We can use its parent entity filter.

Below dataset query could be your reference.

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false" >

  <entity name="tri_offendervictim" enableprefiltering="true">

    <attribute name="tri_name" />

    <link-entity name="dxc_crimereport" from="dxc_crimereportid" to="dxc_crimereportid" link-type="inner" alias="crimereport" enableprefiltering="true" prefilterparametername="CrimeReportId">

    </link-entity>

  </entity>

</fetch>

Pls note,

• Need to enable prefiltering for Victim entity.
• In the linked entity, set the filter for its parent entity, that is CrimeReportId.