I exported the Quote report and Quote Sub-report from an online 2013 instance. Examining the xml and opening it in BIDS show SQL data source and data sets. Why am I not seeing fetch? Is the design for us to replace all this when customizing
an SSIS report?
David is right, built-in reports in CRM Online still use SQL. The bad news is that if you want to modify the built-in reports you need to recreate them using fetchxml, you can't modify the SQL code inside them.
As far as I'm aware, the built-in reports (even in Crm Online) use SQL, rather than Fetch, even though custom reports in Crm Online must be built using Fetch
Microsoft CRM MVP - http://mscrmuk.blogspot.com/ http://www.excitation.co.uk
Proposed as answer byMamatha SwamyThursday, May 1, 2014 5:05 PM
David is right, built-in reports in CRM Online still use SQL. The bad news is that if you want to modify the built-in reports you need to recreate them using fetchxml, you can't modify the SQL code inside them.