Development environment setup for creating D365 (Online) reports in Visual Studio 2019.

(0) Share

Report

Posted on by Community Member

I want to create D365 (Online) reports in Visual Studio 2019. I have installed the SQL Server Data Tools and also create a project for report but in Data Source I do not see the option to connect to CRM Online.
I have setup this environment on a machine which is running on Windows Server 2016 Datacenter.

I have the same question (0)

All responses (7)

Answers (1)

Suggested answer

LuHao 40,892 on at

Like (0)

Report
Hi unaseerb,

I believe this is a result of version differences.

We must install SQL Server Data Tools 2015 and then install Dynamics 365 Report Authoring Extension in order to create reports in SQL Server Data Tools 2015.

Visual Studio is not necessary for creating SSRS, but if we want to use it, we have to install the 2015 version of Visual Studio instead of 2019.

This is the software requirements for creating SSRS in the official document:
https://docs.microsoft.com/en-us/dynamics365/customerengagement/on-premises/deploy/microsoft-dynamics-365-reporting-requirements#dynamics-365-customer-engagement-on-premises-report-authoring-extension-requirements

This is a thread similar to this question:
https://community.dynamics.com/crm/f/microsoft-dynamics-crm-forum/386840/ssrs---report-authoring-extension-not-installing-on-visual-studio-2019

This is a blog introducing Set Up Your Workstation to Create SQL Server Reporting Services Reports for Dynamics 365 Revisited:
https://readyxrm.blog/2018/07/24/set-up-your-workstation-to-create-sql-server-reporting-services-reports-for-dynamics-365-revisited/

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Hi Hao

There is one more issue when I try to install the "Report Authoring Extension" I am getting the following error.

Was this reply helpful? Yes No
LuHao 40,892 on at

Like (0)

Report

Hi reboot,

Please restart your computer before installing the "Report Authoring Extension".

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

I did multiple time. Even tried to install it on different devices still no luck.

Was this reply helpful? Yes No
LuHao 40,892 on at

Like (0)

Report

Hi reboot,

Please try solutions in

community.dynamics.com/.../d365-setup-cannot-continue-because-there-is-a-pending-restart-required-restart-the-computer-and-then-try-running-setup-again-error-while-installing-report-authoring-extension

thusithasblog.blogspot.com/.../microsoft-dynamics-crm-reporting.html

Was this reply helpful? Yes No
Community Member on at

Like (0)

Report

Thanks Hao

It solved the issue.

Was this reply helpful? Yes No
Verified answer

LuHao 40,892 on at

Like (1)

Report

Glad it worked.

Please click Yes under "Did this answer your question?" to close this thread.

Thanks.

Was this reply helpful? Yes No