cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
Saratha30_M
Level: Powered On

SSRS report integrate to Canvas app

I have created a Canvas app. It is connected to Azure SQL server for data manipulation. I would like to integrate SSRS report PDF into the canvas app button.  Is it possible. Or in the Microsoft flow, whether can I create any report PDF format by using the data. Please suggest any idea.  Is it possible by using Power BI, can create a PDF format report.

1 REPLY 1
Super User
Super User

Re: SSRS report integrate to Canvas app

Hi @Saratha30_M

Although I've not tested this, you can export SSRS reports using an URL that looks like this:

https://myrshost/ReportServer?/myreport&rs:Format=PDF

https://docs.microsoft.com/en-us/sql/reporting-services/export-a-report-using-url-access?view=sql-se...

You could try using the PDF control and setting the Document property to this URL. 

https://docs.microsoft.com/en-us/powerapps/maker/canvas-apps/controls/control-pdf-viewer 

Alternatively, you could try opening the URL from within your app with the help of the Launch function.

https://docs.microsoft.com/en-gb/powerapps/maker/canvas-apps/functions/function-param 

 

Helpful resources

Announcements
thirdimage

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

thirdimage

Power Apps Community User Group Member Badge

Fill out a quick form to claim your user group badge now!

sixthImage

Power Platform World Tour

Find out where you can attend!

Power Platform 2019 release wave 2 plan

Power Platform 2019 release wave 2 plan

Features releasing from October 2019 through March 2020

Top Solution Authors
Top Kudoed Authors
Users online (6,906)