142
Hi All,
I have a query in SQL format as below in Dynamic on-premise SSRS and I need to convert it into D365 online SSRS using Fetch XML
SELECT TOP (10) [f-code], Name, [Bus. Phone], Chapter, Company, Trading, Membership, Grp
FROM [MB-MBR]
WHERE ([f-code] = @CRM_FilteredAccount)
I need to convert this into Fetch XML. But I can not find this entity. Please, help me to convert this into fetch XML.
You can refer this page to convert your SQL to FetchXML
Its better to first locate this entity in your advanced Find and there we have an option to download FetchXML also.
Here are some more useful tips when dealing with SSRS Reports
https://vjcity.blogspot.com/2019/05/dynamic-crm-ssrs-report-best.html
https://vjcity.blogspot.com/2019/08/guidelines-to-write-good-javascript.html
Hi,
Where did you get this query from? This doesn't look like correct or complete.
Nonetheless, you can refer the below blog on converting query-
https://arunpotti.wordpress.com/2015/07/12/convert-sql-query-to-microsoft-dynamics-crm-fetchxml/
Hope this helps.
#1
André Arnaud de Cal...
292,850
Super User 2025 Season 1
#2
Martin Dráb
231,723
Most Valuable Professional
#3
nmaenpaa
101,156
Moderator
Share
Report
All responses (
Answers (
