locked
I don't understand SQL Query in CRM 2011 Online ? RRS feed

  • Question

  • Hello,

    There a report that is called "Activities" by default in CRM reports, I download the report and I see the code on visual studio. This is a SQL query that uses a database "Adventures_Work" and I have no database with that name ...


    However when I run my report on the online environment, data belonging to my environment appear in the report.

    I do not understand! This Activities.rdl not use my environment and it works on an online environment using SQL query.

    Can someone explain this to me? Can someone explain this to me? Because according to: a SQL query works on an online environment ... You can even test!

    Thanks'

    Wednesday, June 27, 2012 1:14 PM

Answers

  • Some (maybe all) of the out-of-the-box CRM reports do use SQL queries, rather than FetchXml, even in CRM Online. However, you are not permitted to upload reports that use SQL to CRM Online.

    CRM manages the data source of a report on a CRM server when it is uploaded so that it points to the correct organisation, but when you download the out-of-the-box reports, CRM puts in a dummy data source for AdventureWorks_MSCRM


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


    Thursday, June 28, 2012 10:59 AM
    Moderator

All replies

  • Some (maybe all) of the out-of-the-box CRM reports do use SQL queries, rather than FetchXml, even in CRM Online. However, you are not permitted to upload reports that use SQL to CRM Online.

    CRM manages the data source of a report on a CRM server when it is uploaded so that it points to the correct organisation, but when you download the out-of-the-box reports, CRM puts in a dummy data source for AdventureWorks_MSCRM


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


    Thursday, June 28, 2012 10:59 AM
    Moderator
  • Hi,

    I second David, as he pointed in CRM online you cannot upload SSRS report which use SQL quires. Also almost all the out of box reports have datasource point to Adventure works. 

    On the data source front it does not matter which data source is mentioned in the report which you are uploading as CRM changes the data-source of the the report to point it to correct database. So kind of you need not worry about it. However the change of data-source is not reflected in the rdl file when you will download again. 

    Thanks


    -Devashish
    http://thecrmworld.wordpress.com
    http://ebizartisans.com

    • Proposed as answer by Emile.Korea Wednesday, July 11, 2012 9:34 AM
    Sunday, July 1, 2012 6:00 PM