Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
adminscott
Starting Member
13 Posts |
 Posted - 2008-10-02 : 11:17:00
|
| Hi All,I am an orwcle dba working on SQL Server 2005. I have a very basic knowledge of the SQL Reporting Services Tools through Business Intelligence.I have created a report for a call centre that is to be displayed on multiple TV screens around the office - as such this needs to be showing live data. My issue is that i am unable to find a way of making the report "auto refresh" every x amount of seconds to keep the report up tp date with the current call stats.At the moment we are refreshing IE manually every few minutes but this is both cumbersome and time consuming. I know this can be done using a VB Code but as i am not good with VB is there an easier way? |
|
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
Posted - 2008-10-08 : 20:14:06
|
| You could run the report from windows scheduler to automate. The report web page can also take parameters that determine either your filters on a report and also if the report is refreshed from the DB etc. These are listed in MSDN. If you cannot find them let me know I will have a look for you. |
 |
|
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
Posted - 2008-10-09 : 06:06:28
|
quote:
Originally posted by harlingtonthewizard
You could run the report from windows scheduler to automate. The report web page can also take parameters that determine either your filters on a report and also if the report is refreshed from the DB etc. These are listed in MSDN. If you cannot find them let me know I will have a look for you.
SEE:http://ezinearticles.com/?URL-Parameters-Used-in-Reporting-Services&id=176858http://msdn.microsoft.com/en-us/library/ms155397.aspxand do searches for rs and rc.Use like this in windows scheduler:Run:C:\PROGRA~1\INTERN~1\iexplore.exe http://localhost/ReportServer$SQLExpress?%2fSite+Reports%2fComms+Site+Report&rs:Command=Render&rs:ClearSession=trueStart in:C:\PROGRA~1\INTERN~1 |
|
|
|
harlingtonthewizard
Constraint Violating Yak Guru
352 Posts |
Posted - 2008-10-10 : 08:39:37
|
| You could run this between each report run.http://www.mssqltips.com/tip.asp?tip=1496 |
|
|
|
|
|
|
Auto Refreshing Report