In CRM 4.0 you could host an ASPX or HTML file in the ISV folder. You could then easily use this web page to display SSRS reports, and the code below could be used to rotate through a number of reports.
Of course in Microsoft Dynamics CRM 2011, there is no ISV folder, however you can add the HTML file as a web resource. That then opens the possibility of calling the web resource in to a CRM dashboard, so the reports you pull in just keep refreshing and
rotating.
The HTML to accomplish this is:
<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Transitional//EN" "http://www.w3.org/TR/xhtml1/DTD/xhtml1-transitional.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8" />
<title>Dashboard</title>
</head>
<body style="background-color: #000000">
<br />
<iframe name="rotate" id="rotate" src="about:blank" scrolling="no" framespacing="0" frameborder="0" marginwidth="0" marginheight="0" border="0" style="width:100%; height:768px"></iframe>
<script language="JavaScript" type="text/javascript"><!--
// Pages to rotate
var pages = new Array('Report1', 'Report2');
// Rotation interval, in miliseconds (1000 = 1 second)
var rint = 15000;
var currentpage = -1;
function rotator() {
currentpage++;
if (currentpage >= pages.length) {
currentpage = 0;
}
document.all.rotate.src = pages[currentpage];
setTimeout('rotator()', rint);
}
rotator();
//--></script>
</body>
</html>
Just remember to replace Report1 and Report2 in the variable 'pages' with the URL's of your reports.
