Welcome To The Home Of The Visual FoxPro Experts  
home. signup. forum. archives. search. google. articles. downloads. faq. members. weblogs. file info. rss.
 From: Stephen Hunt
  Where is Stephen Hunt?
 Farmingdale
 New York - United States
 Stephen Hunt
 Tags
Subject: Crystal reports error
Thread ID: 104108 Message ID: 104108 # Views: 2 # Ratings: 0
Version: Visual FoxPro 9 Category: Active X Controls & OLE Automation
Date: Friday, August 11, 2006 3:22:27 PM         
   


I had a problem running a crystal report based off of a SQL Server stored procedure where I could only run the report from the database that the report
was created from. 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

ENTIRE THREAD

Crystal reports error Posted by Stephen Hunt @ 8/11/2006 3:22:27 PM