I have an application that will run Crystal reports for users. For some reports, the application will change the query that the report is based on, depending on the user's choices. Details:
VB 6
Crystal XI
RDC
Some of the queries we use run very long (over an hour) and the Crystal verification process almost doubles the time of the report. For example, we have one report that can be run with one of two queries, each query takes about 6 minutes to run. If the user's selections in the application make it run with the query the report was saved with there are no problems and it runs in 6 minutes. If the query needs to be changed, it takes 6 minutes for the Crystal verification and then another 6 minutes to run doubling the time. The statement I use to change the location is:
We never had this problem in Crystal 8.5. Is there any way of stopping this verification process?
VB 6
Crystal XI
RDC
Some of the queries we use run very long (over an hour) and the Crystal verification process almost doubles the time of the report. For example, we have one report that can be run with one of two queries, each query takes about 6 minutes to run. If the user's selections in the application make it run with the query the report was saved with there are no problems and it runs in 6 minutes. If the query needs to be changed, it takes 6 minutes for the Crystal verification and then another 6 minutes to run doubling the time. The statement I use to change the location is:
Code:
<ReportObject>.Database.Tables(1).Location = <QueryName>We never had this problem in Crystal 8.5. Is there any way of stopping this verification process?