The report was designed with the development database. When the report was opened with the test database, the report was still pointing to Production Database only. I changed the connection information of all the tables but with no effect. When I see the location property of table it points to test2.dbo.tablename. It should be test1.dbo.tablename. How to solve this problem?

i have the same problem. i don't think it is possible. i think it is a bug in crystal and i don't see any patches on their website. also, i am now running into an issue with the .Load() method of a CrystalReports.Engine object. The damn thing shows 3 overloaded methods, but the compiler says "no overloaded method of Load take X parameters" x being the number i put in, i have tried 0, 1 and 2... Crystal Reports blows...it always has and i fear it always will. Sorry this wasn't helpful, I can tell you what i am trying to do: I have an n-tier achitecture system with a single CrystalReports reporter. Each client places a report into a reportqueue table within a db and the reporter takes one at a time and creates the report, then places the resulting file into the sqldatabase and moves on to the next one. The clients then just monitor the db for their report to be done and load the binary data into a viewer. (seems like it should be easy, but the damn load thing is killing me) Chi Happy Decemberween, Everybody!