Custom Reports for Microsoft Dynamics 365

Microsoft Dynamics 365 Reports are based on Microsoft SQL Server Reporting Services and provides the same set of features.

The report definition, both data and layout, of Microsoft Dynamics 365 reports are contained in an .rdl file and the content of this file are based on the Microsoft SQL server report definition language specification.

There are many out of the box reports available and you can create and deploy custom reports as well. Custom reports are of types:

• SQL Based: 
• This reports used SQL queries to retrive the data from filtered view 
• All the default reports are SQL based reports 
• You can't deploy SQL based reports to Dynamics 365 online 

• FetchXML Based: 
• This uses FetchXML to retrive data 
• You can deploy this on both on Dynamics 365 on-premise and online 
• All the reports created using Report Wizard are FetchXML based

Questions/comments/suggestions? please put it in comments below post for further discussion!!!

Follow By Email for more updates directly into your inbox...