Reporting in canvas apps

(0) Share

Report

Posted on by Community Power Pla...

Is there any way we can create a link between canvas app and SSRS reporting? @WarrenBelz

Categories:

Building Power Apps

I have the same question (0)

All responses (7)

Answers (2)

WarrenBelz 153,024 Most Valuable Professional on at

Like (0)

Report

@Anonymous ,

If you use Azure SQL as a backend, I believe it would be compatible with this data source. This would require per-user licenses as you need a Premium Connector.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

Thanks @WarrenBelz - I am using SSMS SQL queries as a data source for SSRS reporting. Is there any way, I can create a button which directly takes me to the SSRS report and also select my parameters in SSRS based on the selection in PowerApps?

Was this reply helpful? Yes No
WarrenBelz 153,024 Most Valuable Professional on at

Like (1)

Report

@Anonymous ,

No, other than possibly hyperlinking to a related URL. There is no connector to this facility.

Please click Accept as solution if my post helped you solve your issue. This will help others find it more readily. It also closes the item. If the content was useful in other ways, please consider giving it Thumbs Up.

Was this reply helpful? Yes No
Verified answer

rebeccas 2,591 on at

Like (2)

Report

We use SSRS for reporting and it is pulling from SQL.

I have apps that are tied to the SQL Tables to view data in the app. Mine have the capability to view only for SQL.

If you are wanting a button or something that takes you directly to SQL you could do that by simply using Launch()

So you would have a button that the OnSelect is Launch("Location of SSRS report"). You pass variables when doing a launch but you would have to work them into your code in the launch.

Typically when passing information it is something that is found in the URL to work but SQL doesn't do normally (ours don't anyhow).

For example you could have Launch("http://YOURDATA/reports/report/YOURDATA/Public/PO%20by%20Job" )

would take you to a specific report but you could have on a selection in the screen that says "PO By Job" the OnSelect be Set(varReport, "PO%20by%20Job") and then the Launch could be:

Launch(Text("http://YOURDATA/reports/report/YOURDATA/Public/" & varReport))

and that would allow the difference. Not sure what type of information you want to pass though.

I hope this helps.

Was this reply helpful? Yes No
Community Power Pla... on at

Like (0)

Report

@rebeccas - Awesome! I think you know what I'm trying to do here. So I want to pass 2 parameters in SSRS report based on my selections in PowerApps. Here is what I'm trying right now-

Launch("http://mysite/Reports/report/Reports/Operations/Myfolder?EmployeeName="& Label2.Text &"?WeekEnd=" &Label3.Text);

Employee Name and weekend date are parameters in SSRS report. I am easily able to run this for my 1st parameter (Employee Name)-

Launch("http://mysite/Reports/report/Reports/Operations/Myfolder?EmployeeName="& Label2.Text);

Trying to find out the syntax for passing the 2nd parameter now.

Was this reply helpful? Yes No
rebeccas 2,591 on at

Like (0)

Report

Sorry I just saw this reply.

It looks like you are close. Getting dates formatted to pass between tools can be tricky. I typically try and just mimic what I see in the address bar as my first try. Did you get it to work?

Was this reply helpful? Yes No
Verified answer

Community Power Pla... on at

Like (1)

Report

Hey @rebeccas - Yes, its actually working for me now 🙂 In SSRS I have the dates as a string which looks similar to date format. The format should basically match to how it looks in your PowerApps.

Launch("WebsiteURL/Reports/report/Reports/Operations?EmployeeName="& Parameter1.Text & "&WeekEnd=" &Parameter2.Text);

Was this reply helpful? Yes No