Dynamics 365 CommunityForums Microsoft Dynamics CRM (Archived) Dynamics 365 SSRS repo...

Dynamics 365 SSRS report to compare 2 entities

(0) Share

Report

Posted on by Community Member Microsoft Employee

Hi, we are using Dynamics 365 and have 2 entities: Account (OOB) and Change Request Account (Custom), both have the exact same fields, having a relationship. Change Request Account is used if there is any change required in the existing Account. There is a requirement to have a report which compares which fields are changed in the Change Request Account record for a particular Account, something like the below format:

Label	Account	CR Account	Changed
Name 1	ABC	ABC	No
Name 2	The Company	The Company	No
Street 1	Dead End Road	Dead Road does not end	Yes
ZIP	40000	60000	Yes
City	Blue Town	Green City	Yes

Is this possible through fetchXML? I am aware that we can't have a field comparison through fetch query. Is there any way to have this kind of report built? Any pointers would be helpful. Thanks!

*This post is locked for comments