Information générale
Forum:
Microsoft SQL Server
Catégorie:
Produits tierce partie
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement