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

0
votes

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?

1
sql-serverreporting-servicesdynamics-crmfetchxml
quick question: Why do you want to change from Fetchxml to SQL? w.r.t Dynamics Fetchxml based report is the supported way. SQL based reports are unsupported. – AnkUser
i need this requirement for some deployment purpose – Shamshad Rizvi

1 Answers

1
votes

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