SSRS 2005 - Updated data not pulling real-time in Reports
I have a web based Java application front-end ticketing software with a SQL Server 2005 DB. Now when bulk updates are entered it can take 1-5 mins for the front-end server to populate the SQL DB, but when I try to run SSRS reports from Report Manager it can take over 30mins for the data to pull. I can go into SSMS and Open the table and see the data in there so now the updates reached the DB but for some reason SSRS will not pull in it's reports. Does anyone have any idea what could be causing this lag? I have SSRS running on the same server as SQL so don't know if this is causing the issue but would think the opposite. Any help would be greatly appreciated. Dallas
January 18th, 2011 4:21pm

Hi Dallas, "now the updates reached the DB but for some reason SSRS will not pull in it's reports." Have you enabled CACHE for the report? Open the report manager, go to the report Properties page and click "Execution" to check "Always run this report with the most recent data" option. thanks, Jerry
Free Windows Admin Tool Kit Click here and download it now
January 20th, 2011 12:17am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics