asked on

SSRS - Auto Advance to either another report or another page

I'm on SQL 2012 using SSRS
I created reports using report builder 3.0

I have the need in my facility to expect SSRS to automatically advance after n seconds to the next page of my report. Or, I would like it to move to another report and continue to loop through this.

I understand SSRS does not do that natively. I really wish it did because we have 60" TV's we use as dashboards and it would be great to automatically advance through a multi page report.

So, what can I use to do this? If you can provide either an example or a website that can help explain how to, I would greatly appreciate it.

SOLUTION

prequel_server

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

ASKER CERTIFIED SOLUTION

ValentinoV

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.

Start Free Trial

BruceLawrence

ASKER

Thanks for the feedback. Both solutions pushed me toward a different one but the second was more in line with what I came up with.

I ended up using an HTML page that basically cycled through a few hyperlinks. Here is the site I got it from:
http://forums.devshed.com/javascript-development-115/cycle-web-pages-618095.html

This code works great
<html>
<head>

<script type="text/javascript">
var pages = [
"http://www.google.com",
"http://www.msdn.com",
"http://www.bbc.co.uk",
"www.yahoo.com"
];
var currentIndex = -1;
function startCycle() {
var iframe = document.getElementById("iframe1");
currentIndex = (++currentIndex) % pages.length;
iframe.onload = function() {
window.setTimeout(50, startCycle); //Currently set to change every 5 seconds
}
iframe.src = pages[currentIndex];
}
window.onload = startCycle;</script>
</head>
<body>
<iframe id="iframe1" frameborder="0" vspace="0" hspace="0" marginwidth="0" marginheight="0"
width="900" scrolling="no" height="900">
</iframe>
</body>
</html>