Hi,
We have just deployed an app and are getting grief over the slowness of reports. This problem has now been trapped down to two lines of code:

myReport.Load(ReportDefnFile)

myReport.SetDataSource(bo.CurrentDataTable)

They each take about 1 minute to execute in the production system but, in our development system, just a couple of seconds. Unfortunately in our development system we often (aka normally) login in as Administrator. However if we login as a normal user we see the same problem. It gets a bit stranger in that if we give a normal user Admin privilages the reports remain slow. They only run at 'normal' speed when run as Administrator.


We are using VS2008 and the production system is Windows Server 2008 SP2, 32 bit and the database in SQL Server 2008. The production system is dual Xeon Processors with 4Gb of memory.


Any ideas would be greatly appreciated.