News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Pulling through N:1 re...

Microsoft Dynamics CRM (Archived)

Pulling through N:1 related entity fields within report

(0) Share

Report

Report

Posted on by Michael_Dawson

5

Hello all,

I've created a custom entity (FPA) which has multiple Pricelist (entity) lookup fields, which then created multiple N:1 relationships between the FPA and Pricelist entities. I need to be able to create a fetchXML report that can pull through the specified Pricelist(s) records and their values to be used within the report. How would i go about achieving this?

Thanks

*This post is locked for comments

All responses Img

All responses (1)

Answers Img

Answers (0)

David Jennaway 14,063 on at

Like (1)

Report
RE: Pulling through N:1 related entity fields within report

The easiest place to start is to create an advanced find to include the relationships you want, and any fields on the main entity and from parent entities, and download the fetchXml. I don't fully understand your relationships, but the 2 main things you'll probably have to do by directly editing the fetchXml are:

Add an attributes that aren't on the main entity or direct parents. You can just add these directly within any entity element

If you have multiple relationships between the same pair of entities, you'll may have to add extra link-entity elements (quite possibly as outer joins), which you can do by copying the initial link-entity elements, ad changing the alias

If you get stuck, try posting the fetchXml of what you have so far, and more detail on the output that you want

Helpful resources

Quick Links

Leaderboard

#1

André Arnaud de Cal... 291,269 Super User 2024 Season 2

#2

Martin Dráb 230,198 Most Valuable Professional

#3

nmaenpaa 101,156

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans