Wednesday, June 27, 2012 1:14 PM
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!
Thursday, June 28, 2012 10:59 AMModerator
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
- Edited by DavidJennawayMVP, Moderator Thursday, June 28, 2012 11:21 AM
- Proposed As Answer by Devashish Bajpai Wednesday, July 11, 2012 9:42 AM
- Marked As Answer by JLattimerMicrosoft Community Contributor, Moderator Tuesday, October 23, 2012 2:23 PM
Sunday, July 01, 2012 6:00 PM
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.
- Proposed As Answer by Emile.Korea Wednesday, July 11, 2012 9:34 AM