I am struggleing to find an answer to my problem. I have seen numerous posts on the net regarding setting all the tables used location property to reference the new database name. But i have this one report that just will not work. All others now work. So i have two databases DB1 and DB2 with the exact same schema and data. The report was created pointing at DB1.

When the location is changed for DB1.dbo.TableName to DB2.dbo.TableName it throws a 'This field name is not known' error message with the InvalidArgumentException.

Yet this works fine when referencing DB1 database.

 

Any one else had this problem. Using Crystal 11 btw.