Hi,
Is it possible to display SSRS report on a K2 SmartForm?
I have a SSRS report that does some calculations on a groupBy column, I am avoiding doing this on a stored procedure because I will have to loop through the records and it takes time. Is there a control on the K2 SmartForm that can be used to display the SSRS report on the screen?
You can use the Content control to link off and display the SSRS report Url.
Cheers
Hey Paulk,
Ended up figuring it out.
Thanks
I was able to display the SSRS Report on a K2 SmartForm using the Content control under Display on the Toolbox, I came across a few issue before I could get it to work like I wanted:
Issue 1: "Mixed Content: The page at 'http://k2devapp...' was loaded over HTTPS, but requested an insecure frame 'http://...'. This request has been blocked; the content must be served over HTTPS."
Solution 1: I installed and configured SSL certificate on the SSRS Sever so that I can access the server over https.
Issue 2: Refused to display 'https://...' in a frame because it set 'X-Frame-Options' to 'sameorigin'.
Solution 2: I added "?&rs:embed=true" to the URL property of the Content control.
Hope someone else finds this helpful.
Enter your E-mail address. We'll send you an e-mail with instructions to reset your password.