Dynamics CRM comes with pre-packaged reports. You can also create your own reports using SSRS. Here we will go through examples of doing this.
Open Visual Studio. Ensure SQL Server Data Tools are installed and the Report Authoring Extensions are installed.
Create a new report project:
This will create a blank project:
Right click Reports and add a new report:
This will open the Report Wizard. Click Next:
Enter the CRM connection string in the following format:
The organization name you can get from Developer Resources in CRM:
Choose a credential type:
Select and click Next.
Select the Query Builder. The query is expecting FetchXML. For the exercise, download the FetchXML from an Advanced Find query:
<fetch distinct=”false” mapping=”logical” output-format=”xml-platform” version=”1.0″>
<order descending=”false” attribute=”name”/>
Click OK and Next:
Select the report type:
Check Preview or click on the Preview tab to view the report:
Go back to the design tab to view the report design:
To deploy, in CRM go to Reports and select New:
Select Existing File and select the RDL file from the Visual Studio project above:
Press Save. The report appears in the list. Click Run Report:
The report is run in CRM: