Monday, 7 August 2017

CREATE SSRS FETCH BASED REPORTS WITH DYNAMICS 365

I  have a requirement to develop ssrs reports on dynamics 365.

These are the steps you need to follow to develop reports on the visual studio 2013 for Dynamics 365:

 Make sure you have installed report authoring extension for the dynamics 365 on visual studio 2013:

Here is the link for it.


Once the tool is installed on the system and then you can see the screen like below screen shot:


It will prompt  for connection string &  username and passport .


Design the Query using Querybuilder:




Then select the fields required for the report.




Build the report and deploy to CRM, go to solutions and select the solution which you are working for the reports and then select the report then click on add existing, select the rdl file, then you are good to go..