💡Run SSRS report on MDA mobile

Hello friends,

Today, I want to share my thoughts on running SSRS reports on Power App Mobile for Model Driven Apps. A key challenge is the absence of the "Run Report" button in the Power Apps Mobile for Model Driven Apps, which means users are unable to generate reports when needed.

For example, in my case: a worker using Power Apps Mobile to manage Work Orders on the field. Once a Work Order is completed, the worker needs to run the "WOSummary" report to display the Work Order information and confirm it with the client. Without the ability to run this report on the mobile app, the worker faces significant inconvenience and inefficiency.

Here, we can see the difference when opening MDA on the Web/Browser and on Power Apps Mobile.

• MDA on Web/Browser: Open the Work Order form, and the "Run Report" button is visible.

• MDA on Power Apps Mobile: Open the Work Order form, and the "Run Report" button is invisible.

My thoughts...

Considering this restriction, my first thought is to implement a new "View Report" button on the main Work Order form.

Okay, I will proceed with my solution and implement it. I'll bypass the step of creating a new command, which you can find in the reference link mentioned earlier.

I will create a new command on the Work Order main form for running the "WOSummary" report on the Selected record. You can see as below.

After creating a button, I modify the PowerFx formula in the OnSelect event: Clicking the "WO Summary" button triggers the system to run a report for the selected Work Order.

By following the link above, I have tried and edited a URL structure as below.

//URL Structure
[organization url]/crmreports/viewer/viewer.aspx?action=run&helpID=[[ReportFileName]]&id=%7b[[ReportGUID]]%7d&context=records&recordstype=[[EntityTypeCode]]&records={[[RecordGUID]]]

My sample: Running report "WOSummary" on Work Order entity.

• [[ReportFileName]]: WOSummary.rdl

• [[ReportGUID]]: 99211b9c-8cde-ee11-904c-0022485a170d

• [[EntityTypeCode]]: Work Order (10327) You can find the entity type code by used FetchXML Builder

• [[RecordGUID]]: Work Order record GUID

Yeah... 🎉, we already found all the components for URL Structure. Now I will put these to my PowerFx formula.

// PowerFx
Launch(
    Concatenate("https://org5bc5a68a.crm5.dynamics.com/crmreports/viewer/viewer.aspx?action=run&helpID=WOSummary.rdl&id=%7b99211b9c-8cde-ee11-904c-0022485a170d%7d&context=records&recordstype=10327&records={",Self.Selected.Item.'Work Order',"}"));

After that, just Save and Publish this command and test it now...

Checking now...

On my phone, I opened the Power Apps mobile and ran my testing app "NTDyns.Asia" > navigate to Work Orders > and open specific a Work Order record.

Hoping well with my thoughts.

Thank you for your reading! ☺️ [NTD]yns.asia