HI,
I want to create a fetch XML report filtering on the basis of Account name
and based upon the selection of Account name it should open up 3 reports(related account)
1.Lead
2.Contacts
3.Opportunity
thanks,
Dev
Hi,
What is the issue you are facing?
You can create dropdown which will contain required Active Account records from CRM.
This can be easily done using fetchxml. In Dropdown Use name field to show the data and backend store account GUIID.
Now create 3 sub reports and pass selected record GUID and create 3 fetchxml data set to get Leads, contacts and opportunity and pass dynamics GUID from parent report to sub reports and replace this ID in your fetch xml.
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,240 Super User 2024 Season 2
Martin Dráb 230,149 Most Valuable Professional
nmaenpaa 101,156