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
2020 release wave 1Discover the latest updates and new features to Dynamics 365 planned through September 2020
Release overview guides and videos Release Plan | Preview 2020 Release Wave 1 Timeline
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 | Upcoming TechTalks
I am trying to create a report using SSRS that will show the subgrid information (if there is information) in a column.
Opportunity name-- Account-- Sub grid of competitors (include competitors name, and rating or anything field to combine in column) -- Status
I am not sure if this can be done in a SSRS report, any help would be great.
I believe combination of LookupSet and Join is what you're looking for - www.inogic.com/.../
Please refer below screenshot and build query from advance find.
It will looks like below, now that you could use in fetchxml
<fetch version="1.0" output-format="xml-platform" mapping="logical" distinct="true"><entity name="competitor"><attribute name="name" /><attribute name="competitorid" /><order attribute="name" descending="false" /><link-entity name="opportunitycompetitors" from="competitorid" to="competitorid" visible="false" intersect="true"><link-entity name="opportunity" from="opportunityid" to="opportunityid" alias="ai"><attribute name="name" /><link-entity name="account" from="accountid" to="parentaccountid" link-type="inner" alias="aj" /><attribute name="name" /></link-entity></link-entity></entity></fetch>
Thank you for your reply Andrew, I will try this method.
Business Applications communities