Breaking news from around the world
Get the Bing + MSN extension
Choose your path Increase your proficiency with the Dynamics 365 applications that you already use and learn more about the apps that interest you. Up your game with a learning path tailored to today's Dynamics 365 masterminds and designed to prepare you for industry-recognized Microsoft certifications.
Visit Microsoft Learn
2019 release wave 2 Discover the latest updates and new features to Dynamics 365 planned through March 2020
Release overview guides and videos Release Plan | View virtual launch event
Ace your Dynamics 365 deployment with packaged services delivered by expert consultants. | Explore service offerings
Connect with the ISV success team on the latest roadmap, developer tool for AppSource certification, and ISV community engagements | ISV self-service portal
The FastTrack program is designed to help you accelerate your Dynamics 365 deployment with confidence.
FastTrack Program | Finance TechTalks | Customer Engagement TechTalks | Talent TechTalks | Upcoming TechTalks
I try to display in my CRM report the list of opportunities and associated users of an N*N relationship already created in Dynamics.
We have achieved this by using the grouping option, but we want a smoother solution with SSRS.
What I've tried so far:
I created two datasets; the first one recovering all opportunities
The second one for the users and their associated opportunities
I got something lik this :
After that in my table, I tried to use LookUpSet in my expression to get the associated users
=Join(LookupSet(Fields!opportunityid.Value, Fields!saft_systemuser_opportunity94aa154e_opportunityid.Value, Fields!saft_systemuser_opportunity94aa154e_systemuserid.Value , "DataSet3"),",")
I didn't get any results, but when I tried with another data set containing only the intersection table, it worked well but I still need the fullname field.
=Join(LookupSet(Fields!opportunityid.Value, Fields!opportunityid.Value, Fields!systemuserid.Value , "DataSet2"),",")
I just want to know if there other solution to do that ?, and is mine not working because it's a two level lookup and it's not supported by the function ?
Business Applications communities