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

Question

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?

Answer 1

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.