Report writing guide for Dynamics 365 Customer Engagement (on-premises), version 9.x

Microsoft Dynamics 365 Customer Engagement (on-premises) includes reports, charts, and dashboards that provide useful business information and visualizations to the user.


This guide is also applicable for Microsoft Dataverse. You can follow the information in this guide to create and edit fetch-based reports that can run in Dataverse. The following reporting topics are available in the Dataverse documentation:

Paginated reports

Customer Engagement (on-premises) includes a Report Wizard that can be used to easily create SQL Server Reporting Services reports in just a few steps without using XML or SQL-based queries. For more information about the Report Wizard, see Create, edit, or copy a report using the Report Wizard.

However, to create more complex reports, you can either create your own custom SQL Server Reporting Services reports from scratch, or use an existing report as a template. The topics in this guide show you how to create new reports or change existing reports using Visual Studio as the report writing tool and SQL Server Reporting Services as the report engine.

Charts and dashboards

Charts allow app users to view the data presented in a view in a range of ways, which include bar, pie, and line charts. An entity can have multiple charts associated with it, and the charts themselves provide interactivity that enables a user to select a bar and the view will filter accordingly. Add multiple charts to create an effective dashboard.

There are two types of dashboards in Customer Engagement (on-premises)—user dashboards and system dashboards. Any user can create a dashboard visible only to them in their work area, such as Sales, Service, or Marketing. An administrator or customizer creates or customizes system dashboards that, when published, are visible to everyone in the organization. A user can choose to set their user dashboard as their default dashboard and override the system dashboard. More information: Create or customize dashboards


Embedded Power BI tiles and dashboards are not supported with Microsoft Dynamics 365 Customer Engagement (on-premises).