I recently came across a requirement where I had to create an SSRS report for Dynamics 365 for a client. This doesn’t sound that easy. Even being in the Dynamics CRM field for quite some time, I had faced several issues while creating the report, so I decided to document the process of creating the report that can be helpful for others.
Environment Setup:
I used Visual Studio 2015 for creating the report. However, you can use the 2017/19 versions as well. Make sure that the SQL Server Data Tools is installed. We also need to install the Dynamics 365 Report Authoring Extension. You can download it from here:
After creating the project, the first thing you need to do is add a report to your project. To do that, right-click on the reports folder, select Add/New Item.
Select “Report”, give a name for the report, and click Add.
Make sure the report is selected (there is a black fill around the name). Click on View/Report Data.
Now you will see the Report Data bar. The first thing you need to do is add the data source for the report. To do that right-click on Data Sources and click Add Data Source.
You will now see the data source properties window. Give a name for the Data Source.
Ensure that the “Embedded connection” radio button is selected and the type is “Microsoft Dynamics 365 Fetch.”
After entering the data, the screen will look something like this:
NOTE: There are 2 parts in the connection string separated by the semicolon( ; ) The first part is the organization URL. This is the URL you enter in the browser to connect to the Dynamics 365 environment. The second part is the Organization name. To get the organization name, go to Settings/Advanced Settings/Customizations/Developer Resources. The unique name is the one highlighted below. Copy that and paste it in the connection string.
Next, you need to enter the credentials. Choose the “Use this user name and password” and enter the credentials you use to connect to your Dynamics 365 environment and Click Ok.
For any questions related to this blog or Dynamics 365, connect with us.
2 thoughts on “Create an SSRS report for Dynamics 365 – Part 1”
Mukarram
Appreciate your efforts. Keep helping us like this. Now please make a guide how can I become CRM technical consultant/developer. I know C# and Javascript but how to use, when to use, where to use.
Thanks, Mukarram. You might be interested in others blogs too https://www.ahaapps.com/blog/. Hope you find them interesting too ????
Comments are closed.
This website uses cookies to improve your experience. We'll assume you're ok with this, but you can opt-out if you wish. Cookie settingsACCEPT
Privacy & Cookies Policy
Privacy Overview
This website uses cookies to improve your experience while you navigate through the website. Out of these cookies, the cookies that are categorized as necessary are stored on your browser as they are essential for the working of basic functionalities of the website. We also use third-party cookies that help us analyze and understand how you use this website. These cookies will be stored in your browser only with your consent. You also have the option to opt-out of these cookies. But opting out of some of these cookies may have an effect on your browsing experience.
Necessary cookies are absolutely essential for the website to function properly. This category only includes cookies that ensures basic functionalities and security features of the website. These cookies do not store any personal information.
Advertisement cookies are used to provide visitors with relevant ads and marketing campaigns. These cookies track visitors across websites and collect information to provide customized ads.
Any cookies that may not be particularly necessary for the website to function and is used specifically to collect user personal data via analytics, ads, other embedded contents are termed as non-necessary cookies. It is mandatory to procure user consent prior to running these cookies on your website.
Analytical cookies are used to understand how visitors interact with the website. These cookies help provide information on metrics the number of visitors, bounce rate, traffic source, etc.
Performance cookies are used to understand and analyze the key performance indexes of the website which helps in delivering a better user experience for the visitors.
Appreciate your efforts. Keep helping us like this. Now please make a guide how can I become CRM technical consultant/developer. I know C# and Javascript but how to use, when to use, where to use.
Thanks, Mukarram. You might be interested in others blogs toohttps://www.ahaapps.com/blog/ . Hope you find them interesting too ????