Skip to main content
Dynamics 365 Community / Forums / Sales forum / Reporting using fetchxml

Reporting using fetchxml

editSubscribe (0) ShareShare
Posted on by 1,942
Hi All,
I have an out of box entity called opportunity and created two custom entities called opportunity contracts and opportunity service lines with one to many relationship. I am trying for an online fetchxml report using visual studio 2019. I am trying to use lookupset in conjunction with join function to print the child columns in a comma separated value with in the same column. It works for opportunity to opportunity service lines, and the same formula is not working for opportunity opportunity contract.
Formula for service lines: =Join(LookupSet(Fields!opportunityid.Value,
Fields!mms_servicelineid.Value, ,OppSLines),/,/)
Formula for contract lines: =Join(LookupSet(Fields!opportunityid.Value,
Fields!mms_contracttype.Value, OppCon),/,/)