Search code examples
sql-serverreporting-servicesdynamics-crmfetchxml

How can I convert FetchXML Data-Source to SQL server Data Source?


I has created a SSRS report of CRM Dynamics using FetchXML, but now I want to create the report using SQL server, but I am stuck at converting Data-Source.

Any suggested solution?


Solution

  • I have used this couple of times. Try the XrmToolBox FetchXML builder, choose SQL Query from the View menu. This will show the SQL equivalent of FetchXML.

    enter image description here