One of the big new features in Microsoft Dynamics CRM 2011 is the use of Dashboards and Charts that are available at a glance instead of having to run a report. One of our clients has a lot of people out in the field and they wanted to be able to view a report in a Dashboard instead of having to run the report.
If you are using CRM Online and you create this as a Personal Dashboard, you will see the error “This content cannot be displayed in a frame.” If you are using CRM On Premise with an IFD environment, you will be prompted for your IFD credentials again; however, even after entering them, you are still unable to view the report in the Dashboard.
The reason you are unable to view the report in a Personal Dashboard is because the option to Restrict cross-frame scripting is checked, and you are unable to un-check it. In order to be able to un-check this option, you must create this as a System Dashboard with these steps. When you remove this check mark, all CRM users (regardless of their domain) will be able to access the IFrame, which is most likely located in another domain.
- Go to Workplace > Reports and find the report you want to appear in the Dashboard.
- Highlight this report and click Run Report in the ribbon.
- Once the report has ran, hit Control + N on your keyboard. This will open the Report in a new window.
- In the new window, highlight the entire URL and hit Control + C to copy this.
- Go to Settings > Customizations > Customize the System.
- Click on Dashboards and click New.
- Choose the appropriate dashboard layout. The steps I will use involve removing the rest of the dashboard so only the report is visible.
- Click on each of the items in the Dashboard and click Remove in the ribbon.
- Click Iframe.
- Type a name for the Iframe with no spaces. This is a unique name to be saved in the database and not anything that the end users will see.
- Paste the URL that you previously copied into the URL box.
- The Label defaults to what is in the Name area; change here if you wish. This is the label that the end users will see, so also check the box next to Display label on the Dashboard.
- Un-check the box next to Restrict cross-frame scripting.
- Click OK.
- With the IFrame highlighted in the box, click Increase Width so it takes up the entire width of the Dashboard.
- Optionally, you can click Increase Height as much as you would like to show more of the report in the dashboard.
- Type a name for the Dashboard and click Save and Close.
- Click Publish All Customizations.
For information online, download the white paper released by the CRM Software Blog, “24 Wildly Creative Ways Companies Use Microsoft Dynamics CRM to Drive Revenue and Serve Customers” that discusses how Dynamics CRM can improve your business. They also have a quick online quote tool for Dynamics CRM pricing customized to your business’ needs.
Since 1989, DFC Consultants has been providing accounting software solutions, training and support in our offices in Fargo, Bismarck, and Dickinson, North Dakota. Our passion is to assist clients in meeting their goals with professional services and powerful business solutions.
By Andrea Lange, CRM Applications Consultant at DFC Consultants, North Dakota CRM Partner