Create SSRS Report for Dynamics365 PowerApps Record with a Custom Ribbon Button

Step 1:
Create a new project in Visual Studio 2019 with Report Server Project Template
Step 2:
Add Data source in the Project file using Microsoft Dynamics 365 Fetch with the Connection String
If the Microsoft Dynamics 365 Fetch is not available in the Type we need to Install below two Extensions
Install Dynamics 365 Report Authoring Extension - 2019
Dynamics 365, version 9.0 Report Authoring Extension (with SQL Server Data Tools support) - 2019

PowerApps Image

Step 3:
Create a new File in the Reports folder selecting the option as Report

Step 4::
Now Create a Shared Datasets with the Name Dataset1 and we need to select the Data Source and the Type should be text and now we need to add FetchXml in the Query and click on the Query Designer to check whether the given FetchXml working or not. After Clicking the Query Designer a pop-up will shown to confirm the data source user or not give your mailId and password.

PowerAutomate Image

After clicking the Query Designer the below Pop-up will be shown need to give username and password

PowerAutomate Image

Step 4.1:
In this step we can Create a report as we required with these options

PowerAutomate Image

Here is the sample report with the Fields name and values added as expressions.

PowerAutomate Image

Step 4.2:
Add Report1.rdl file in the power apps and the record type should be existing file and we need to choose the categories and select the Related record Type is (entity) and we can check the report by using Run Report Option.

PowerAutomate Image

Step 4.3:
After adding the Report1.rdl file in PowerApps now we need to write a JavaScript code and add the file in the PowerApps web resource to trigger the ribbon button report.

PowerAutomate Image

Now create a Solution for Ribbon Button and add existing entity with no components .

Step 5:
Use XRMToolBox to Create a Ribbon Button and add the JavaScript Command to the button .


Create SSRS Report for Dynamics365 PowerApps Record with a Custom Ribbon Button

Eekshith Pavan Kumar, Dynamics CRM Developer

We Work to Help You Grow

Izenix educate and explain practical performance and configurations for fast check and best outcomes

We Are Here For You

Let�s Get Back to Work

Getting a better understanding of Izenix's specialized services and solutions

Schedule for Free Demo