[Okta Webinar] Learn how to a build a cloud-first strategyRegister Now

x
?
Solved

SSRS - Scrolling Reports

Posted on 2012-09-20
2
Medium Priority
?
482 Views
Last Modified: 2012-09-20
Hi

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?
0
Comment
Question by:sagarh
2 Comments
 
LVL 22

Accepted Solution

by:
Nico Bontenbal earned 2000 total points
ID: 38417435
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:
http://technet.microsoft.com/en-us/library/ee176580.aspx
to let the script wait use this:
http://technet.microsoft.com/en-us/library/ee156589.aspx
0
 

Author Closing Comment

by:sagarh
ID: 38417874
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 10seconds....works a treat

Thankyou!!
0

Featured Post

Free Tool: Subnet Calculator

The subnet calculator helps you design networks by taking an IP address and network mask and returning information such as network, broadcast address, and host range.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Written by Valentino Vranken. Introduction: In a previous article (http://www.experts-exchange.com/articles/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Reporting-On-Data-From-Stored-Procedures-part-1.html) I announced that I would writ…
A recent question popped up and the discussion heated up regarding updating a COMMENTS (TXT) field in a table using SSRS. http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/MS-SQL_Reporting/Q_27475269.html?cid=1572#a37227028 (htt…
This Micro Tutorial will teach you how to add a cinematic look to any film or video out there. There are very few simple steps that you will follow to do so. This will be demonstrated using Adobe Premiere Pro CS6.
Exchange organizations may use the Journaling Agent of the Transport Service to archive messages going through Exchange. However, if the Transport Service is integrated with some email content management application (such as an anti-spam), the admin…
Suggested Courses
Course of the Month19 days, 15 hours left to enroll

873 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