# SQL Server Reports in an IFrame

**URL:** <https://forum.inductiveautomation.com/t/sql-server-reports-in-an-iframe/40708>\
**Category:** Ignition\
**Tags:** perspective, ignition80\
**Created:** [November 16, 2020, 9:26pm UTC](https://forum.inductiveautomation.com/t/sql-server-reports-in-an-iframe/40708 "2020-11-16T21:26:20Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![m.boog](https://avatars.discourse-cdn.com/v4/letter/m/f6c823/32.png) [@m.boog](https://forum.inductiveautomation.com/u/m.boog)\
**Post date:** [November 16, 2020, 9:26pm UTC](https://forum.inductiveautomation.com/t/sql-server-reports-in-an-iframe/40708/1 "2020-11-16T21:26:20Z")

</div>

Has anyone successfully displayed a SQL Server Report Services report within a Perspective IFrame? I’m using Perspective in 8.0.16. I can call the URL **[http://localhost/ReportServer/Pages/ReportViewer.aspx?/CasesRunPerHour%20BarChart&rs:Command=Render](http://localhost/ReportServer/Pages/ReportViewer.aspx?/CasesRunPerHour%20BarChart&rs:Command=Render)**  
in Chrome on the same server as the Gateway, and get a nice graph. When I call it within an IFrame, I get a nice “localhost refused to connect”.

I followed the instructions from PGriffith’s [post](https://docs.inductiveautomation.com/display/DOC80/Gateway+Configuration+File+Reference#GatewayConfigurationFileReference-XFrameOptions) to turn off the x\_frame options in Ignition.conf. Without any change.

(Yes, I’m aware that Ignition can also create reports, I’m looking into this option for my manager 🙂 )

Wondering if anyone successfully accomplished this before.

Thanks!

---

<div class="post-metadata">

**Author:** ![pturmel](https://sea1.discourse-cdn.com/inductiveautomation/user_avatar/forum.inductiveautomation.com/pturmel/32/3295_2.png) [@pturmel](https://forum.inductiveautomation.com/u/pturmel)\
**Post date:** [November 16, 2020, 9:29pm UTC](https://forum.inductiveautomation.com/t/sql-server-reports-in-an-iframe/40708/2 "2020-11-16T21:29:33Z")

</div>

You’ll probably have to update the content security policy(ies) in Report Services. (No, _I_ don’t know how to do that…)

---

<div class="post-metadata">

**Author:** ![m.boog](https://avatars.discourse-cdn.com/v4/letter/m/f6c823/32.png) [@m.boog](https://forum.inductiveautomation.com/u/m.boog)\
**Post date:** [November 17, 2020, 4:25pm UTC](https://forum.inductiveautomation.com/t/sql-server-reports-in-an-iframe/40708/3 "2020-11-17T16:25:37Z")

</div>

Thank Phil for the quick response. I spent a fair amount of time learning about CSP and HTTP headers. Very informative, but unfortunately didn’t resolve the problem.

Turns out the solution was rather simple, for anyone who comes across this use case. All I had to do was append “&rs:Embed=true” to the end of the URL, and the IFrame rendered the page.