NothandoKhumalo
Scholar

Displaying SSRS Report On a K2 SmartForm

Jump to solution

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?  

Labels: (1)
0 Kudos
Reply
3 Replies
paulk
Scout

Re: Displaying SSRS Report On a K2 SmartForm

Jump to solution

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

 

Cheers

Reply
NothandoKhumalo
Scholar

Re: Displaying SSRS Report On a K2 SmartForm

Jump to solution

Hey Paulk,

 

Ended up figuring it out.

Thanks 

0 Kudos
Reply
NothandoKhumalo
Scholar

Re: Displaying SSRS Report On a K2 SmartForm

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

0 Kudos
Reply