join SQL with FetchXML RRS feed

  • Question

  • I have a current  have a report that is based on CRM Database and my custom Database 

    I left outer join my custom database with CRM Database and the report works fine

    but we will be moving to CRM online in a couple of months and i have to convert all the report to CRM online

    since I dont have access to the database anymore i will have to use FetchXML to get the data

    How can i join a SQL table with FetchXML 

    thank you for all the help 

    Thursday, March 15, 2012 2:46 PM

All replies

  • FetchXml can only retrieve data that's in the Crm database. So, you'll only be able to get this to work with Crm Online if you move the data from the custom database into Crm.

    The link-entity element of FetchXml will allow you to join to other entities within the Crm database

    Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk

    Friday, March 16, 2012 6:14 AM