Dynamics CRM 2011 Online default Reports not editable

In CRM 2011 Online the available out of the box reports are not customizable and users are able to download the *.*RDL Files although after editing it in SQL Server 2008 R2 Business Intelligent Development Studio, you won’t be able to upload then back into CRM Online. You are unable to create sub reports for an already existing report on CRM 2011 Online.

This is because RDL Sandboxing is enabled for CRM Online. This will allow you to upload into CRM 2011 Online only FetchXml Reports, and you will be unable to upload any SQL query based SSRS reports on CRM 2011 Online.

 

The allowed namespaces, types, and members included into these FetchXML reports are found in the following article:

http://msdn.microsoft.com/en-us/library/hh547428.aspx

The following Information and article are very helpful for beginning with FetchXML Reporting on CRM Online:

a. On CRM Online you can’t edit the default reports which you can download as *.*RDL files from within the reports entity

b. RDL Sandboxing is enabled; the following features are disabled for RDL files in the CRM Online Environment:

• Custom code in the <Code> element of a report definition

• RDL backward compatibility mode for SQL Server 2005 Reporting Services custom report items

• Named parameters in expressions such as DateFormat or NameSpace

• For more details please read the following KB article:

http://support.microsoft.com/kb/2600639/en-us

c. Please check out the following blog articles which are describing the following topics regarding FetchXML Reports:

i. Getting Started with CRM 2011 Online Fetch XML Reporting:

http://garethtuckercrm.com/2011/03/24/fetch-xml-reports-for-crm-2011-online

ii. Images in your CRM reports – Photos with FetchXML Reports:

http://www.powerobjects.com/blog/2011/09/21/images-in-your-crm-reports-powerphoto-with-fetchxml-reports

 

Best Regards

EMEA Dynamics CRM Support Team