155
I want to generate an SSRS report that has information about contact fields : emailaddress1,parentcustomerid. The report should display old value,new value, updated by information. Please post any links or suggestion on implementing this.
Env : 2015 On-Prem
trying to use this https://marcuscrast.wordpress.com/2012/01/14/dynamics-crm-2011-audit-report-in-ssrs/ but not sure how to retrieve lookup display names.
HI Itz_me_ram,
you have to use link entity for example a fetch below:
<attribute name="name" />
<attribute name="primarycontactid" />
<attribute name="telephone1" />
<attribute name="accountid" />
<order attribute="name" descending="false" />
<link-entity name="opportunity" from="parentaccountid" to="accountid" link-type="inner" alias="aa">
<link-entity name="contact" from="contactid" to="parentcontactid" link-type="inner" alias="ab">
<filter type="and">
<condition attribute="contactid" operator="eq" value="@contactId" />
</filter>
</link-entity>
</link-entity>
other example you can use in powerbi = LOOKUPValue(contacts[fullname],contacts[contactid],accounts[_primarycontactid_value])
regards,
#1
André Arnaud de Cal...
292,494
Super User 2025 Season 1
#2
Martin Dráb
231,309
Most Valuable Professional
#3
nmaenpaa
101,156
Share
Report
All responses (
Answers (
