cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Frequent Visitor

Reporting in canvas apps

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

6 REPLIES 6
Highlighted
Super User III
Super User III

@VS325 ,

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.

Highlighted

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?

Highlighted
Super User III
Super User III

@VS325 ,

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.

Highlighted
Super User
Super User

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.

 

Highlighted

@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. 

Highlighted

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? 

Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

News & Announcements

Community Blog

Stay up tp date on the latest blogs and activities in the community News & Announcements.

secondImage

Power Platform 2020 release wave 2 plan

Features releasing from October 2020 through March 2021

Community Highlights

Community Highlights

Check out the Power Platform Community Highlights

Top Solution Authors
Top Kudoed Authors
Users online (12,995)