SSRS - Scrolling Reports

Posted on 2012-09-20
Last Modified: 2012-09-20

I have a couple of Reporting Services reports whch work well that management would like me to put on a large screen in the sales office....

I like to be able to get the reports to cycle from one to the other etc. without user input but do not know how to do this - any ideas on how I can achieve this?
Question by:sagarh
    LVL 22

    Accepted Solution

    You might be able to use the AutoRefresh property for this. When you set this the report will refresh after the number of seconds set in the property. But that would only refresh the current report. So you can create a main report that holds all the reports as subreports. Set all those subreports to invisible except one. The trick is to determine which one. You could use a stored procedure that increments the value of a field in a table by one and returns the new value. Based on this number you could determine which subreport to show. You could also use the current time and do a mod on that to determine the report to show.

    Another approach would be to write some vb script that starts IE and navigates to the first report. Then the script pauses for a few minutes and the next report is loaded. And at the end of the list it returns to the first report again. You can find some more information about this here:
    to let the script wait use this:

    Author Closing Comment

    Fantastic! I used the first option of several sub reports linked to a variable which works!

    The main report looks up a value in a table - in turn that value is updated by a stored procedure which runs every a treat


    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Written by Valentino Vranken. A while ago I wrote an article called Chart Optimization Tips (  This article explained how …
    Introduction As you'll probably know, a data region in a SQL Server Reporting Services report can be linked to only one dataset.  This makes it troublesome when you need to display data from more than one dataset in the same data region.  SQL Serve…
    In this sixth video of the Xpdf series, we discuss and demonstrate the PDFtoPNG utility, which converts a multi-page PDF file to separate color, grayscale, or monochrome PNG files, creating one PNG file for each page in the PDF. It does this via a c…
    In this tutorial you'll learn about bandwidth monitoring with flows and packet sniffing with our network monitoring solution PRTG Network Monitor ( If you're interested in additional methods for monitoring bandwidt…

    729 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    20 Experts available now in Live!

    Get 1:1 Help Now