Set Up Your Workstation to Create SQL Server Reporting Services Reports for Dynamics 365 Revisited

Summary

  • The process to set up a workstation to create SQL Server Reporting Services (SSRS) reports for Dynamics 365 involves a lot of steps and causes some confusion.
  • The report authoring tool is Visual Studio, but a full licensed version of Visual Studio is not required.
  • The Dynamics 365 Report Authoring Extensions has been recently updated to address TLS 1.2 requirements of Dynamics 365 v9

Revisited

A couple of years ago I wrote a posting on how to set up a workstation to create SSRS reports for Dynamics 365/CRM.  It turned out to be one of my more popular posts.  If you are writing reports for older versions of Dynamics 365/CRM, those instructions are still very relevant.

Click here for the original post.

Since that post, there have been a couple of updates and also an issue with connecting to Dynamics 365 v9 in regards to TLS 1.2 when using an older version of the Report Authoring Tool.

Recently, Microsoft has released Dynamics 365 Report Authoring extensions for Dynamics 365 v9.

This post is updated to reflect the update tools and processes to get you creating SSRS reports for Dynamics 365 in no time!

Note that these instructions will also work if you want to create SSRS reports for Model Driven PowerApps on a Common Data Service environment.

Visual Studio Data Tools

The first step is that you will need to install Visual Studio Data Tools 2015.  You DO NOT need to have a fully licensed version of Visual Studio 2015 Professional or Enterprise.  However, if you do have Visual Studio 2015, you will be able to write SSRS reports from that version after following these steps.

Note that the Visual Studio Data Tools are FREE.

Click here to get to the Visual Studio Data Tools download page.

Once the page loads, click on the “Download SQL Server Data Tools” link to download the package.

assdt1

The file SSDTSetup.exe should download.  When complete, run the program to install the tool.  You will need to have administrative permissions on your workstation.

When prompted, choose to install SQL Server Reporting Services.  Click Next.

assdt2

Read the license terms carefully, and if you don’t find anything objectionable, click the box to agree to the terms and conditions and click Install.

assdt3

The process will install the SQL Server Data Tools on your environment.

assdt4

Eventually, the setup will complete.  Click Close.

assdt5

This is all you need to write SSRS Reports if you are able to access a SQL Server database directly and use Transact-SQL as the query language.  This would be the case for Dynamics 365 on-premise systems or if you want to write reports based on Azure SQL (If you utilize Dynamics 365 Data Replication).  However, even if you run Dynamics 365 on-premise, it would be a good practice to write reports using FetchXML when you will eventually move to Dynamics 365 Online.  To write FetchXML based reports, you will need to load the Dynamics 365 Report Authoring Extensions.

Dynamics 365 Report Authoring Extension

The Dynamics 365 Report Authoring Extension is an add-on for SQL Server Data Tools that will allow you to write reports using the FetchXML language.  This currently is the only method to write SSRS reports that can access Dynamics 365 Online data directly.

Click on the link below to get to the download page.

Dynamics 365 Report Authoring Extension

IMPORTANT!  Make sure you download version 9.0!  You will be able to write reports for Dynamics 365 Online 8.2, but it’s better to have up-to-date tools.  You can still access previous versions but will require some workarounds to work with Dynamics 365 Online v9 due to Dynamics 365 Online v9 enforcing the TLS 1.2 standard.

assdt6
Ensure you have version 9.x!

You should have now downloaded the file “CRM9.0-Bids-ENU-i386.exe” (name may change slightly if you are downloading a different language)

assdt7

Extract the package to a folder on your workstation and continue the install.  I would recommend you choose to get updates to make sure you have the latest version and patches.  Click Next.

assdt8

There may or may not be updated files to install.  Click Next.

assdt9

Read the license agreement and click on the accept checkbox and click I Accept to continue.

assdt10

You may (or may not) be prompted to install some additional updates.  Choose to Install to update these components.

ssdtdl12

Choose whether or not you want to use Microsoft Update.  Click Next.

assdt11

Choose the installation location.  Click Next.

assdt12

The installation process will check the system.  Click Next to continue.

assdt13

Confirm the installation directory and click Install to initiate the process.

assdt14

After a few minutes, the installation process will complete.  Click Finish.

assdt15

The Dynamics 365 Report Authoring extension and SQL Server Data Tools are now installed on your workstation and you can begin to author SSRS reports for Dynamics 365.

If you aren’t familiar with writing Dynamics 365 SSRS reports, check out my post to get started.

ssrsreportsetup

How to Create Your First Dynamics 365 SSRS Report

Nick Doelman is a Microsoft Business Application MVP and used to write Dynamics CRM Crystal Reports back in version 1.0/1.2.  We have come a long way!

9 thoughts on “Set Up Your Workstation to Create SQL Server Reporting Services Reports for Dynamics 365 Revisited

  1. Don’t know if you’ve run into it but coincident with the latest W10 Update 2019-05 I can no longer edit reports. I now get the message “Unknown Report Version: 9.0”. It’s been working for months before this update.

    Like

  2. Don’t know if you’re run into this or not but coincident with the 2019-05 Windows 10 update I can no longer edit reports in VS 2015. I receive the error “Unknown Report Version: 9.0” and cannot save the report in VS. This has been working for months prior to this update.

    Like

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google photo

You are commenting using your Google account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s