Hello Experts,
I have a requirement, Where I have to fetch values from 2 different data set only if customer match.
two entities are not related to each other
Is there any way to match these value and bring them in single table
or is there any way to merge this in fetch xml
please help
Thank you
*This post is locked for comments
Hello,
Thanks for the response
is there any way I can match customer name from 2 different datasets in SSRS report than put in tablix of ssrs
thank you
Hi,
No, without the relationship between the entities you cannot join the 2 entities. You will have to either create a relationship as suggested above
Hope this helps.
I don't think you will be able to match and join them in FETCH when there is no relationship at all.
One thing you could do is to add a relationship, do a bulk update using a workflow and then use the FETCH to get the data you want
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
André Arnaud de Cal... 291,253 Super User 2024 Season 2
Martin Dráb 230,188 Most Valuable Professional
nmaenpaa 101,156