Great content delivered right to your mailbox

Thank you! Check your inbox for our monthly recap!

The digital era has arrived and, according to the World Economic Forum, the digital economy is expected to be worth $100 trillion within next 10 years. The digital economy is underpinned by data and this is why the volume of data is increasing exponentially day-by-day; therefore, the businesses that make sense of the flow of information have a competitive edge in the marketplace.


Click here to download our free ebook on Dynamics 365 and get answers to your questions!


Are you familiar with the super powers of data reports?

The crucial thing is to have access to the data in a way that makes business sense and helps the managers to resolve business problems, understand customer patterns, and, more important, discover an opportunity.

There are few data analytics case studies from the retail industry:
  • milk was found to be the most purchased item so it is always placed at the back of the store, making the customers walk past everything else before they get to milk
  • bananas are at the front of stores because they are found to be an impulse buy
  •  men who buy diapers for their kids are more likely to have beer in their carts

To get to this kind of discovery, a data mining exercise and the combining of data from multiple systems is necessary; however, the precursor is a strong foundation of data.

Dynamics reports statistics benefits

Microsoft Dynamics 365 platform offers a robust and flexible foundation that captures and reports on the business data to be further used for business analytics. In this article, we will explore Microsoft Dynamics 365 (CRM) capabilities that enable business users to get easy access to data via reporting without IT or vendor help. Business users have the capability to configure their own reports at a lower cost rather than undergoing a change via IT. The custom reports, however, require technical knowledge.

Have You Heard About The Incredible Reporting Capabilities of Dynamics 365 (CRM)?

Microsoft Dynamics 365 (CRM) is seamlessly integrated with Microsoft SQL Server Reporting Services (SSRS), enabling the platform to host complex business reports based on the data residing in CRM.

Two types of SQL Server Reporting Services (SSRS) reports can be generated in Microsoft Dynamics 365 (CRM).

  • Report Wizard Reports
  • Custom Reports

What do Wizard Reports look like?

These reports are comparatively less complex reports and can be created by using the Report Wizard within the Dynamics 365 (CRM) web application. This functionality enables the business analysts and business users to create reports quickly without a developer’s help. The wizard can summarise and display data from two types of records at once.
Dynamics 365 Wizard Report

Some capabilities of the Report Wizard’s reports are listed below.
  • The report can have tables and charts with a clickable reference to the specific CRM record.
  • Report data can be grouped by any field and summarized by aggregations such as sum, average, minimum, maximum, and percentages.
  • Report Wizard allows users to configure filtering criteria using logical operators such as “AND” and “OR”.
  • Report Wizard also allows users to configure filtering criteria using:
    • Data comparison operators such as “Equal”, “Does not Equal”, “Is Greater Than”, “Is Less Than”, “Contains Data” and “Does Not Contain Data”.
    • Date comparison operators such as “On”, “On or Before”, “On or After”, “Next X Days”, “Last X Days”, “Today”, and so on.
  • Advanced users, such as business analysts, can write comparatively complex reports utilizing logical operators, comparison operators, and grouping options.
  • Report creation is controlled by Dynamics CRM’s Security Model. The users with appropriate privileges will only be able to create custom reports either using Report wizard or SSRS reports.
  • Report Wizard has some limitations and is designed to enable users to create comparatively less complex reports.

What are Custom Reports?

The complex SSRS reports can be developed and imported into Dynamics 365 (CRM). Under the hood, the custom-developed SSRS reports and Report wizard reports are structured in a similar XML format.

As mentioned earlier, Report Wizard reports have some limitations and there is a clear distinction between configuring vs. customising, i.e., writing a custom SSRS report. For example, a Report Wizard report cannot group data from more than two record types.
Dynamics 365 Custom reports

Therefore, it is recommended to create Report Wizard reports if the requirement is limited to the configuration scope. Business users can also minimize the cost by configuring a foundation report enabling the technical people to extend it further for complex grouping or aggregation using Microsoft SQL Server Reporting Services (SSRS).

How does it work in a business scenario?

Consider a scenario that a business user wants to report on the open cases with its key data points grouped by the account (customer). The guide below covers the steps required to configure the report.

Step-by-Step Guide

Step 1: Click “Service”

Dynamics 365 Wizard Reports

Step 2: Click “Reports”

Dynamics 365 Wizard Reports

Step 3: Click “New” to create a new report

Dynamics 365 Wizard Reports

Step 4: Specify a name and configure as shown in the screenshot

Dynamics 365 Wizard Reports

Step 5: Select “Start a new report” and click “Next”

Dynamics 365 Wizard Reports

Step 6: Select “Case” as “Primary record type” and click “Next”

Dynamics 365 Wizard Reports

Step 7: Specify the filtering criteria 

Dynamics 365 Wizard Reports

Step 8: Click “Click here to add a grouping” to specify the grouping object in the report 

Dynamics 365 Wizard Reports

Step 9: Add Grouping as shown below

Dynamics 365 Wizard Reports

Step 10: Click “Click here to add a column” to add columns from the Case entity

Dynamics 365 Wizard Reports

Step 11: Add columns as shown in the screenshot

Dynamics 365 Wizard Reports

Step 12: Select “Table Only” and click “Next”

Dynamics 365 Wizard Reports

Step 13: Proceed with the wizard and then Click “Finish” to create the report

Dynamics 365 Wizard Reports

Step 14: Click “Run Report”

Dynamics 365 Wizard Reports

Step 15: Review the newly created report

Dynamics 365 Wizard Reports

Resell Dynamics 365

Written by Daniel Burla Employee @ SherWeb

A versatile IT Business and Technical Analyst with 10+ years participating in IT projects of the main business solutions in the market (SAP, Oracle and Dynamics 365). That allows me to confidently provide innovative advice on complex issues, articulating options and solutions regardless the chosen platform.