For any organization, reports are an integral part to helping your team’s function whether it’s to pass information to your clientele or to discover realities.
There are many reporting tools for Dynamics 365. Some of the most common tools are:
Which tool should you use? Well, that entirely depends on your use case. Below is an outline with a few of the top benefits and limitations of each:
Report Wizard in Dynamics 365
- Easy for a power user to create and configure
- Limited to connecting 2 relational datasets (i.e. a parent and child entity)
- Limited to a tabular or matrix format
- Can easily configure them to run from a single record or multiple
- Security is based on the Dynamics 365 users security role(s)
- Unable to schedule them on a recurring basis out of the box in Dynamics 365 online
SSDT with the Dynamics 365 Report Authoring Extension
- A power user can create these, but it may require a bit of upfront training
- Can connect more than 2 data sets using FetchXML
- Very flexible on how the report is formatted
- Can display in a common tabular or matrix format
- Can add images
- Can add headers and footers
- Can display multiple child tables (with the help of a sub report)
- Can add prompts (e.g. a date range, a team/user) to help end users running the report to filter the data
- Can add/remove sorting features
- Can adjust the width so that it is formatted properly for your export format of choice (Word, PDF, Excel, etc)
- Can import to Dynamics 365 which will then behave similar to one that was developed using the Dynamics 365 report wizard tool:
