SSRS fetchxml data for 2 entities

(0) Share

Report

Posted on by Community member

Hello,

I have a main entity then I have another entity that has one to many relationship that is a list. Is it possible to get the entire list of records with fetchxml? I would like to display the data from the main entity and the related records from the other entity in SSRS.

All responses (1)

Answers (1)

Verified answer

PerezAguiar on at

Like (0)

Report

SSRS fetchxml data for 2 entities

Hey!

on FetchXML you have the option to use <link-entity>. You have some documentation on https://stackoverflow.com/questions/53216249/understanding-link-entity-in-fetchxml and https://learn.microsoft.com/en-us/power-apps/developer/data-platform/fetchxml/join-tables?tabs=fetchxml. Basically, this means that you can use link-entity and specify an alias, as well as the column that works on the relationship.

Regards,

******
I hope this answer has helped you solve your problem. If you are satisfied with it, please consider marking it as the excellent answer by clicking on the green check mark below. This will help other users who have similar questions find the best solution.

Thank you for your feedback!