Creating Dynamics CRM Reports with SSRS and Fetch XML

Leave a comment

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:

http://crmurl;organizationname;

For example:

http://localhost:5555/;CarlCo;

The organization name you can get from Developer Resources in CRM:

Select credentials:

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:

<?xml version=”1.0″?>

<fetch distinct=”false” mapping=”logical” output-format=”xml-platform” version=”1.0″>
<entity name=”account”>

<attribute name=”name”/>

<attribute name=”primarycontactid”/>

<attribute name=”telephone1″/>

<attribute name=”accountid”/>

<order descending=”false” attribute=”name”/>

</entity>

</fetch>

Execute it:

Click OK and Next:

Select the report type:

Table style:

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:

 

THANKS FOR READING. BEFORE YOU LEAVE, I NEED YOUR HELP.
 

I AM SPENDING MORE TIME THESE DAYS CREATING YOUTUBE VIDEOS TO HELP PEOPLE LEARN THE MICROSOFT POWER PLATFORM.

IF YOU WOULD LIKE TO SEE HOW I BUILD APPS, OR FIND SOMETHING USEFUL READING MY BLOG, I WOULD REALLY APPRECIATE YOU SUBSCRIBING TO MY YOUTUBE CHANNEL.

THANK YOU, AND LET'S KEEP LEARNING TOGETHER.

CARL

https://www.youtube.com/carldesouza

 

ABOUT CARL DE SOUZA

Carl de Souza is a developer and architect focusing on Microsoft Dynamics 365, Power BI, Azure, and AI.

carldesouza.comLinkedIn Twitter | YouTube

 

Leave a Reply

Your email address will not be published. Required fields are marked *