The problem was that the stored procedure location set in the report included the database name "databasename.dbo.Proc(receipt;1)". I had to take out the database name in the reports by just leaving Proc(receipt;1). Then before I executed my report I had to set the datafiles(0)=Proc(receipt;1). Now I can execute my report from multiple databasenames. The problem I am having now is that the subreports also contain the database name. I changed the location in the reports then in my program I am issuing
.datafiles(0)=Proc(receiptsubreport;1)
.subreporttochange="receiptsubreport"

I am no longer getting the error 20599 Cannot Open SQL Server.
but I am now getting error 20534 Error detected by database dll

When I remove the subreport from the main report everything works fine
When I remove the 2 line of code
.datafiles(0)=Proc(receiptsubreport;1)
.subreporttochange="receiptsubreport"

I get the error 20599 Cannot Open SQL Server.

Any Ideas ?
Thanks Again