Tag: FetchXml Reports

MS CRM 2013: Issues uploading report to CRM Online

19/01/201410/05/2017 | by Andrew Butenko | Leave a Comment

Today, I was faced with a really weird issue with a Report developed for CRM Online. The Report worked fine both at BIDS and my test On-Premise instance, but once I’ve tried to upload it to the productive instance I got following error: I’ve downloaded the description file, but the error log didn’t contain any …

Reports

MS CRM 2011: T-SQL Union operation and FetchXml based reports

09/11/2012 | by Andrew Butenko | 2 Comments

I believe every person who developed complex reports for CRM used T-SQL Union operation to display different types of records at the same table. In T-SQL I used following T-SQL Query to get results:

Select
    AccountId RecordId
    ,Name RecordName
    ,'account' RecordTypeName
From FilteredAccount
Union
Select
    ContactId RecordId
    ,FullName RecordName
    ,'contact' RecordTypeName
From FilteredContact

Select

AccountId RecordId

,Name RecordName

,'account' RecordTypeName

From FilteredAccount

Union

Select

ContactId RecordId

,FullName RecordName

,'contact' RecordTypeName

From FilteredContact

And results were: When CRM 2011 was released we got possibility to create reports for CRM Online but it is …

Reports

MS CRM 2011: Sharing Summary Report

07/08/2012 | by Andrew Butenko | 10 Comments

Sharing is amazing feature which is available in Dynamics CRM. Unfortunately it is not easy to say which record is shared with whom and which privileges are provided. I have created report using which you can get this information.

#Stand­With­Ukraine

#StandWithUkraine