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?
Solved! Go to Solution.
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.