Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Microsoft Dynamics CRM (Archived)

Embed SSRS Report in IFrame inside Dashboard

(0) ShareShare
ReportReport
Posted on by

Hello everyone, 

I'm having an issue and I've wasted too much time on this.

Let's keep this short and sweet.
I'm trying to embed a basic SSRS Report in an IFrame and display it on a Dashboard.

Following this documentation: https://srmscrm.wordpress.com/2013/04/15/370/ , it did not take me more than 10 minutes to have my report rendered on the dashboard. I only made one adjustment to the report URL:
Ex: /crmreports/viewer/viewer.aspx?action=run&helpID=TestExample.rdl&id=%7bEECA0726-BD78-E911-A985-000D3AF49637%7d - did not work.
Ex2: /crmreports/viewer/viewer.aspx?action=runl&id=%7bEECA0726-BD78-E911-A985-000D3AF49637%7d - did work.


Near the end of the day, I noticed my report wasn't rendering anymore:

crmreportbug.PNG

I reverted every change I had made during that day, no effect. 
I've followed everything I could find:
https://weblogs.asp.net/pabloperalta/how-to-display-a-report-in-a-dashboard-in-dynamics-crm-2011

https://community.dynamics.com/crm/b/meganwalker/archive/2017/09/12/display-a-report-in-a-crm-dashboard

https://www.quantacrm.com/2016/11/23/show-report-dashboard-component-dynamics-365/

http://www.powerxrm.com/add-report-to-dashboards-in-crm-20152016/

https://ledgeviewpartners.com/blog/turn-report-dashboard-dynamics-crm/

https://crmtipoftheday.com/43/embed-a-pre-filtered-report-in-an-iframe/

Let's recap our steps: 
1) Create Report (Report Runs correctly on it's own)
2) Create Dashboard
3) Insert IFRAME 
4) Specify information (Name, URL, Label, Uncheck 'Pass record object-type code and unique identifier as parameters' and 'Restrict cross-frame scripting, where supported')
 -I've tried every recommended variation of the URL:
 a) https://myorg.crm3.dynamics.com/crmreports/viewer/viewer.aspx?action=run&helpID=TestExample.rdl&id=%7bEECA0726-BD78-E911-A985-000D3AF49637%7

 b) https://myorg.crm3.dynamics.com/crmreports/viewer/viewer.aspx?action=run&id=%7bEECA0726-BD78-E911-A985-000D3AF49637%7

 c) /crmreports/viewer/viewer.aspx?action=run&helpID=TestExample.rdl&id=%7bEECA0726-BD78-E911-A985-000D3AF49637%7d
 d
/crmreports/viewer/viewer.aspx?action=run&id=%7bEECA0726-BD78-E911-A985-000D3AF49637%7

They all render: 
crmreportbug.PNG

The server IP address works, it runs the report when pasted in the browser. 

I  tried using an HTML Web Resource that links to the Report as mentioned in this doc:
http://www.powerxrm.com/add-report-to-dashboards-in-crm-20152016/

I also tried scrapping everything and starting from scratch, still doesn't work.

I know this has to be a very ridiculous reason. I need help, this is frustrating. Thank you very much

*This post is locked for comments

  • PabloCRP Profile Picture
    1,088 on at
    RE: Embed SSRS Report in IFrame inside Dashboard

    Indeed set the url makes the report run, but how to make it dynamics the URL so there's no need to change that pannel's URL when pass the solution among environments, Any update?

  • Community Member Profile Picture
    on at
    RE: Embed SSRS Report in IFrame inside Dashboard

    Hi Kokulan,

    Thanks for the reply. This indeed fixes the issue, but the URL is not dynamic. I'm looking to make my URL dynamic so that when we deploy from environment to environment, my IFRAME doesn't break. Can you please help me with this issue. Thank you!

  • Kokulan Profile Picture
    18,054 on at
    RE: Embed SSRS Report in IFrame inside Dashboard

    Hi

    Your error message clearly states that it assumes crmreports is a host name and its trying to resolve that to an IP address and it does not exist.

    Please try the following

    Run the report on its own and copy the URL and only change the action from filter to Run and keep everything else as is.

    Paste this full URL for IFRAME URL and see if it still complains about IP.

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

🌸 Community Spring Festival 2025 Challenge Winners! 🌸

Congratulations to all our community participants!

Adis Hodzic – Community Spotlight

We are honored to recognize Adis Hodzic as our May 2025 Community…

Kudos to the April Top 10 Community Stars!

Thanks for all your good work in the Community!

Leaderboard > Microsoft Dynamics CRM (Archived)

#1
Mohamed Amine Mahmoudi Profile Picture

Mohamed Amine Mahmoudi 83 Super User 2025 Season 1

#2
Community Member Profile Picture

Community Member 52

#3
Victor Onyebuchi Profile Picture

Victor Onyebuchi 6

Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans