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.
Category: 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 …
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:
|
1 2 3 4 5 6 7 8 9 10 11 |
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 …
MS CRM 2011: General approaches to generation of reports
Following article describes general steps to use web services of Reporting Services.
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.