Dynamics Community Forum Thread Details

SSRS Report, unable to get proper data through link entity

Hello everyone, am working on SSRS report and am facing issue with link entity as am not getting proper data. I have multiple tables to link, so am trying to get info by linking with one table first, data is inappropriate. sharing the fetxml for reference.

<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="false">
<entity name="investinfo" enableprefiltering="1">
<attribute name="investinfoid" />
<attribute name="invesid" />
<attribute name="createdon" />
<attribute name="todaysdate" />

<order attribute="investid" descending="false" />
<link-entity name="summaryofinc" from="summaryofincid" to="oi_investinfo" alias="summary" link-type="inner">
<attribute name="summaryofinc" />
<attribute name="allegationid" />
<attribute name="descriptionofinc" />
<attribute name="odateentered" />
<filter type="and">
<condition attribute="summaryofincallegationid" operator="eq" value="@investinfoid" />
</filter>
</link-entity>
</entity>
</fetch>

Categories:

Microsoft Dynamics CRM

Quick Links

Subscribe to this forum!