You’re offline. This is a read only version of the page.
106
Hello,
I am trying to create a report using SSRS that will show the subgrid information (if there is information) in a column.
for Example:
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.
thank you,
Joseph
Thank you for your reply Andrew, I will try this method.
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>
Hello Joseph,
I believe combination of LookupSet and Join is what you're looking for - www.inogic.com/.../
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
291,240
Super User 2024 Season 2
#2
Martin Dráb
230,149
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (