SQL Server Reporting Services is one of the most popular components of SQL Server. It is based on a server-based report generation software system from Microsoft. It can be used to prepare and deliver a variety of interactive and printed reports. It is administered via a web interface. Reporting services features a web services interface to support the development of custom reporting applications. Microsoft Dynamics 365 – Custom Reports • Custom Reports Contains Two Reports • Fetch Xml Reports • SQL Server Reports.
When running the SSRS installation, you will need to install the Database Engine and SQL Server Reporting Services in Native mode. It is easier to install both services at one time, because you can choose to have the installation process configure the SSRS services for you. If SSRS is installed later, or if you select not to configure it at installation, you will have to configure it manually. During installation, be sure to select these features:
If given the choice, select Install and Configure.
To be able to create SSRS reports for Dynamics 365 using Visual Studio, you need to perform the following actions:
Once you have completed these steps, you are ready to start creating SSRS reports for Dynamics 365. The following sections explains how you can create SSRS reports using FetchXML from Dynamics
In Dynamics 365, click Advance Find.
If multiple CRM Organizations are available, there may be dialog box which may ask you to Login or select the right organization. Provide the credentials and Login to relevant organization.
In the Solution Explorer, right-click on the Project and click Properties. In the Target Server Version field, select SQL Server 2008 R2, 2012 or 2014. Click Apply. Then build the RDL and import RDL file in Dynamics 365.