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 …
Tag: FetchXml Reports
MS CRM 2011: T-SQL Union operation and FetchXml based reports
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 And results …
MS CRM 2011: Sharing Summary Report
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.