Hi,
I made a main report that contains one subreport. Both reports are based on a stored procedure.
I use Crystal reports (.NET)
In the subreport (stored procedure), I add the name of the database as a parameter.
--> ex. sql query : select * DATABASE.dbo.person
When I run my main report I get an error:
<< Not supported.
Details: ADO Error Code: 0x80040e37
Source: Microsoft OLE DB Provider for SQL Server
Description : Invalid object name '.dbo.person'.
SQL State: 42502
Native Error: 208
>>
It looks like the subreport is already coming up before the main report did. In that case the subreport did not get on time the parameters from the main report, including the important parameter databaseName!
cfr error: ???.dbo.person.
Although, after this error it works fine in Crystal reports but when I call this report from my .NET program I get the error "Failed to Open Rowset".
Can anyone help me?
with regards,
Informat
I made a main report that contains one subreport. Both reports are based on a stored procedure.
I use Crystal reports (.NET)
In the subreport (stored procedure), I add the name of the database as a parameter.
--> ex. sql query : select * DATABASE.dbo.person
When I run my main report I get an error:
<< Not supported.
Details: ADO Error Code: 0x80040e37
Source: Microsoft OLE DB Provider for SQL Server
Description : Invalid object name '.dbo.person'.
SQL State: 42502
Native Error: 208
>>
It looks like the subreport is already coming up before the main report did. In that case the subreport did not get on time the parameters from the main report, including the important parameter databaseName!
cfr error: ???.dbo.person.
Although, after this error it works fine in Crystal reports but when I call this report from my .NET program I get the error "Failed to Open Rowset".
Can anyone help me?
with regards,
Informat