Does the stored procedure have the same owner in each of the databases? If not, that's probably where your problem is. Also, changing the location of stored procs in Crystal itself can be tricky - it's not always straight-forward - so I'm not surprized that you're having problem changing it in code. Is there any way that you can use tables instead of a stored proc?
-Dell