How can deploy custom SQL-based reports to Microsoft Dynamics CRM Online , If Can't How can change SQL-based reports to FetchXML Reports?

Question

How can deploy custom SQL-based reports to Microsoft Dynamics CRM Online , If Can't How can change SQL-based reports to FetchXML Reports ?

I made Report rdl SQL-based (Advanced Query) and when to attach it on MS CRM 2013 Online , it can't upload it , because it supports FetchXML only , so if can change my SQL-based report rdl to FetchXML Report.

I made Report rdl SQL-based (Advanced Query) and when to attach it on MS CRM 2013 Online , it can't upload it , because it supports FetchXML only , so if can change my SQL-based report rdl to FetchXML Report . — Mena Magdy

Guido Preite Guido Preite · Accepted Answer · 2014-11-12T13:29:57

Dynamics CRM Online supports only FetchXML reports.

If you have SQL-based reports you need to convert them to use FetchXML instead of SQL queries.

You can try also this service to help you with the conversion

http://sql2fetchxml.com/

How can deploy custom SQL-based reports to Microsoft Dynamics CRM Online , If Can't How can change SQL-based reports to FetchXML Reports?

1 Answers