Hi,
I have designed a report file using CR7 and I have deployed this report to a web server (Windows 2000 Server SP4) using CR9. I am displaying the report using the RDC in my ASP application. The data set is a SQL Server 2000 stored procedure with varchar parameters. My report contains 7 subreports. I have other reports which have been built in a similar fashion and that contain subreports. I have verified that the stored procedure is returning the correct results and that the error is not coming from the database.
The error message that I am receiving is "Query Engine Error: 'This operation is not valid for a closed connection.'" This message is displayed in the Report Designer. I have applied service pack 2 for Crystal Reports.
I have tried the following: Saved the report in Version 9, removed all subreports but I still get the same error message. The strange thing is if I refresh the report after acknowledging the error message the report runs as expected.
My feeling is that a particular dll does not load into memory which is required in this report and not required by other report files. My question is, how do I determine which dlls are required by a rpt file given that I have not created any custom ufls?
Thank you.
Fred
I have designed a report file using CR7 and I have deployed this report to a web server (Windows 2000 Server SP4) using CR9. I am displaying the report using the RDC in my ASP application. The data set is a SQL Server 2000 stored procedure with varchar parameters. My report contains 7 subreports. I have other reports which have been built in a similar fashion and that contain subreports. I have verified that the stored procedure is returning the correct results and that the error is not coming from the database.
The error message that I am receiving is "Query Engine Error: 'This operation is not valid for a closed connection.'" This message is displayed in the Report Designer. I have applied service pack 2 for Crystal Reports.
I have tried the following: Saved the report in Version 9, removed all subreports but I still get the same error message. The strange thing is if I refresh the report after acknowledging the error message the report runs as expected.
My feeling is that a particular dll does not load into memory which is required in this report and not required by other report files. My question is, how do I determine which dlls are required by a rpt file given that I have not created any custom ufls?
Thank you.
Fred