How to fetch data from three different entities using fetch xml query in SSRS reports into one single report.

(0) Share

Report

Posted on by Sandy Hello

340

I want to fetch data from three different entities, say e.g. Entity C is child to Entity B and B is child to Entity A, I want to fetch data using fetch xml query from all the three different entities in to one single report, how can this be achieved.

All responses (4)

Answers (1)

Suggested answer

Sandy Hello 340 on at

Like (0)

Report

RE: How to fetch data from three different entities using fetch xml query in SSRS reports into one single report.

Thanks Leah for your response advance find option helped me to fetch query for all the three entities together, but i have not used any xrmtoolbox here. Below code helped me.

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

<entity name="A">

<attribute name="X" />

<link-entity name="B">

<attribute name="Y" />

<link-entity name="C">

<attribute name="Z" />

</link-entity>

</link-entity>

<filter type="and">

</filter>

</entity>

</fetch>
Suggested answer

Pawar Pravin 5,227 on at

Like (0)

Report

RE: How to fetch data from three different entities using fetch xml query in SSRS reports into one single report.

In addition with above suggested answer, create link entity relation in advance find and once you download it then change inner to outer in xml relationship
Verified answer

Community Member Microsoft Employee on at

Like (0)

Report

RE: How to fetch data from three different entities using fetch xml query in SSRS reports into one single report.

Hi Sandy,

You can use Advanced Find to build fetch xml and download it, which is easy.

As you mentioned, Entity C is child to Entity B and B is child to Entity A.

1.Go Advanced Find.

2.select parent entity as your need, then select related entities under ‘Related’, and as the same operation for third entity.

3.clcik Download Fetch Xml.

Also, you can try to use (FetchXml Builder ) xrmtoolbox.

(1) select one entity.

(2) right click entity A, click Add and link-entity, and you can click Select attributes to select fields you need.

(3) Result view.

Regards,

Leah Ju

Please mark as verified if the answer is helpful. Welcome to join hot discussions in Dynamics 365 Forums.
Scosec 95 on at

Like (0)

Report

RE: How to fetch data from three different entities using fetch xml query in SSRS reports into one single report.

Hi Sandy,

You can create a <link-entity> inside your fetchxml to join related entities.

Also you could choose to install the XRM toolbox. There is a FetchXML builder that makes it pretty easy to select the appropiate data.

Link: https://www.xrmtoolbox.com/

Microsoft docs: docs.microsoft.com/.../use-fetchxml-construct-query