locked
Why does rdl file come down with SQL data source and datasets? RRS feed

  • Question

  • 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?
    Thursday, May 1, 2014 4:19 PM

Answers

  • 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.

    My blog: www.crmanswers.net - Rockstar 365 Profile

    • Marked as answer by mardukes Thursday, May 1, 2014 7:53 PM
    Thursday, May 1, 2014 5:48 PM

All replies

  • 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 by Mamatha Swamy Thursday, May 1, 2014 5:05 PM
    Thursday, May 1, 2014 5:04 PM
    Moderator
  • So, do I modify the SQL and the form and import it?  Do I have to replace it all with fetch?
    Thursday, May 1, 2014 5:39 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.

    My blog: www.crmanswers.net - Rockstar 365 Profile

    • Marked as answer by mardukes Thursday, May 1, 2014 7:53 PM
    Thursday, May 1, 2014 5:48 PM