Hi,
You can use the following steps:
1. Run the report you want to display in a Dashboard.
2. Press F11 or Ctrl+N to get the Url of the report. Copy the URL.
3. Create a New Dashboard. Don’t worry about the layout, you will modify it completely in next steps.
4. Remove all objects created by default and insert an IFRAME in the Dashboard.
5. Paste the above Url after making the following adjustments to it:
- Remove “http://myserver/myorg” . This will make your url relative.
- Replace “?action=filter” with “?action=run”. This will bypass the first step before running the report where CRM asks for some parameters.
for instance, if the original url was:
http://crm-vm/MyOrg/crmreports/viewer/viewer.aspx?action=filter&helpID=My%20Report%20Name.rdl&id=%7bE70C6DCA-31FF-E011-807F-000C293AE41E%7d
..then, you should write:
/crmreports/viewer/viewer.aspx?action=run&helpID=My%20Report%20Name.rdl&id=%7bE70C6DCA-31FF-E011-807F-000C293AE41E%7d
6. Also, clear checkbox ‘Restrict cross-frame scripting’ . At least in my case I had to do that to make it work.
7. Use the buttons ‘Increase Width’ and ‘Increase Height’ so as to make the IFRAME fill the whole page of your Dashboard (or just the space it’s supposed to need).
8. Save & Close the Dashboard.
9. Publish the Dashboard.
10. Try It! :) . You should see your Dashboard listed in the available dashboards and the report once it’s selected
. You would probably need to make more minor adjustments to size / layout but at this point you should have achieved the main purpose which is displaying the report ;).
https://community.dynamics.com/crm/b/pabloperalta/archive/2011/10/26/how-to-display-a-report-in-a-dashboard-in-dynamics-crm-2011.aspx#.US-PHzDvtQY
Hope this helps.
-----------------------------------------------------------------------
Minal Dahiya
blog : http://minaldahiya.blogspot.com.au/
If this post answers your question, please click "Mark As Answer" on the post and "Vote as Helpful"
