Dataset of Parent Entity creation in SSRS for D365

 Dataset of Parent Entity creation in SSRS for D365

Let's see the example diretly.

The SSRS report comes from the specified CrimeReport entity record.

Youth entity is parent entity of CrimeReport.

In the SSRS report, need some info from the lookup field Youth.

Need to create a dataset for the parent Youth entity record.  

So, need to define the parameter Youthid to filter the Youth record, then create the dataset query for it.

Below steps could be your reference.

Firstly, create the parameter Youthid manually. 

This parameter comes from its child entity CrimeRport record.

Next, create the dataset query for Youth, using the parameter created in the first step to filter.

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

<entity name="account">

    <attribute name="name" />

    <attribute name="tri_offenderid" />

    <attribute name="tri_dob" />

    <filter>

      <condition attribute="accountid" operator="eq" value="@Youthid" />

    </filter>

  </entity>

</fetch>