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.

All Forums  Development Tools  Reporting Services Development  auto time and auto updates in report-SSRS

Author  Topic  kiri Starting Member 38 Posts Posted - 2008-02-01 : 11:59:04 My report in SSRS does update only when i run that query in MS access. I migrate the 97 database to 2003 ms access database. I imported that report in ssrs using import tool in ssrs. i have set up shared data sources using odbc connection to ms access database. auto refresh works only when i manually run query in ms access. Here's my query....it has several table. SELECT Call_Completed_by_Engineer_Daily.FullName, Call_Completed_by_Engineer_Daily.[Remaining Calls], Call_Completed_by_Engineer_Daily.[Fairfax Calls], Call_Completed_by_Engineer_Daily.[SystemS Calls], Call_Completed_by_Engineer_Daily.[AACPS Calls], Call_Completed_by_Engineer_Daily.[NSN Calls], Call_Completed_by_Engineer_Daily.[MVA Calls], Call_Completed_by_Engineer_Daily.[Other Calls], Call_Completed_by_Engineer_Daily.[Total Calls], Call_Completed_by_Engineer_Daily.[All Tech], Call_Completed_by_Engineer_Daily.Department FROM Call_Completed_by_Engineer_Daily WHERE (((Call_Completed_by_Engineer_Daily.FullName) Not Like 'Jim Rowland*' And (Call_Completed_by_Engineer_Daily.FullName) Not Like 'Bill Bockmiller*' And (Call_Completed_by_Engineer_Daily.FullName) Not Like 'Hong Nguyen*' And (Call_Completed_by_Engineer_Daily.FullName) Not Like 'Hossein Talaei*' And (Call_Completed_by_Engineer_Daily.FullName) Not Like 'James Hawkins*' And (Call_Completed_by_Engineer_Daily.FullName) Not Like 'Joe Cooley*' And (Call_Completed_by_Engineer_Daily.FullName) Not Like 'Peter Threatt*')); This is a final query that i am getting report from. They are other queries that grab the information from table. For example, FullName query - Remaining Calls - Fairfax Calls...... FullName Remaining Calls Fairfax Calls SystemS Calls AACPS Calls NSN Calls MVA Calls Other Calls Total Calls All Tech Department Jay Brittain 10 4 4 JB DC Jeremy Ditto 2 2 1 3 JD DC Jing Kenny Hu 8 1 1 1 3 JKH DC Phone Soe 11 1 2 3 PS DC This is datasheet view of that query. I imported access report to sql reporting service. i can see it that report in web server too. However, i have to hit refresh every time. Can you tell me where to set up time? i want autorefresh time with all auto updates information. can anyone help me??