I am having a problem with the distribution of my reports. I develop my reports on Windows NT 4.0 and Crystal Reports 8.0, using a OLE DB connection to a SQL2000SP1 database. My problem is, that when QA tests my application, they run their database on a 'named instance' of SQL 2000.
IE, instead of server name: JOE it's JOE\PRODUCTNAME
this is fine and dandy most of the time, but for some reason my reports which contain fully linked subreports do NOT work correctly. (the subreports are in a detail section with parameter filled by the resultset of my main report).
Any help would be appreciated, I've already logged 17 hours on this problem and the only thing I've been able to break it down to is the named instance.
Just to show I've tested, I ran my application on Windows 2000 and SQL Server 2000 (not a named instance) and it worked.
I backed up the database, restored to a named instance, ran the same application and it would NOT work.
The Crystal Error I am getting is:
"Error detected by database DLL"
Thanks!
IE, instead of server name: JOE it's JOE\PRODUCTNAME
this is fine and dandy most of the time, but for some reason my reports which contain fully linked subreports do NOT work correctly. (the subreports are in a detail section with parameter filled by the resultset of my main report).
Any help would be appreciated, I've already logged 17 hours on this problem and the only thing I've been able to break it down to is the named instance.
Just to show I've tested, I ran my application on Windows 2000 and SQL Server 2000 (not a named instance) and it worked.
I backed up the database, restored to a named instance, ran the same application and it would NOT work.
The Crystal Error I am getting is:
"Error detected by database DLL"
Thanks!