Microsoft BI Reporting Services not displaying report data quickly even though data is retrieved quick RRS feed

  • Question

  • We have an issue here where our SQL 2008 R2 (Prod) and 2003 (DEV) view runs very quick (less than 10 seconds) to retrieve an entire fiscal year of data using  the Web Sql Server Reporting Services but the data does not actually get displayed back onto the screen for at least another 30 minutes where the user could possibly do something with it. It has been confirmed the problem is not with SQL, the DB, hardware or memory.

    The problem is somewhere in the Microsoft BI Report Server / Web Reporting Services configuration but I am not very familiar with these so I am not sure where to begin looking. Are some services needed that are possibly not turned on or is there some configuration that may be wrong?

    Thank you in advance for any ideas on where I may find the issue related to this long delay in displaying the report data onto the screen.

    Friday, February 11, 2011 5:42 PM