SQL Server 2005 Report Services only works on development

I have a large number of reports that only seem to load when working with MS Visual W开发者_StackOverfloweb Developer Express. When I put application into production, all my reports just spin and then show nothing.

We need a lot more information to give you a good answer. There are many reasons why this could happen. One possibility - the data source is different on the server than on your local PC. Keep in mind - when you deploy a report to a SQL Server Reporting Services server, and you overwrite an existing report, your newly deployed report will keep the old data source of the report you're overwriting; It will not automatically use the datasource you were using on your development machine if it was previously using something else.

Check in profiler if the Database dou think is accessed is accessed by reportserver.

If not check the datasource in http://yourreportserver/reports/

Have you tried running IE8 in compatability mode?

@mike, as you said, while you already check and recheck the data source but still some user can use the report, and some other dont.

Lets have some scenario. User A work on PC A001 can use the report, while user B, work on PC B001 cannot use the report. Please recheck whether user A still able to use the report in PC B001? if that the case, the problem is in the user right. but if not the problem is in IE/machine configuration.

hope that helps.