Category: Reports

Blog, Development, Howto, Reports

Microsoft Dynamics 365 v9.0: How to fix connectivity issues between SSDT + Report Authoring Extension and Dynamics 365

At the moment (February 14, 2018) Microsoft hasn’t released version of Report Authoring Extension that supports both v9.0 and enforced TLS 1.2. This post will help people who develops reports for latest Dynamics 365 v9.0 using SQL Server Data Tools and FetchXml Authoring Extension.

Reports

MS CRM 2013: Issues uploading report to CRM Online

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

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 …