Solved

Displaying SSRS Report On a K2 SmartForm

  • 4 February 2022
  • 3 replies
  • 49 views
N
Badge +2

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?  

icon

Best answer by NothandoKhumalo 9 February 2022, 10:28

View original

3 replies

P
Userlevel 3
Badge +9

You can use the Content control to link off and display the SSRS report Url.


 


Cheers

N
Badge +2

Hey Paulk,


 


Ended up figuring it out.


Thanks 

N
Badge +2

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.

Reply


View our Community Site Map

Nintex Community Sitemap
Terms & ConditionsCookie settings