Crystal Reports 8.5 report runs stored procedure twice

103 Views Asked by At

I created a report that uses a SQL Server stored procedure as a data source. Through the use of SQL Server Profiler I found out that when loading the report in our application the report runs the stored procedure 2 times instead of just 1 time. The first time it runs with the parameters that where used to create the report and the second time ut runs with the parameters that the application specified. The first run is unnecasary and causes the report to load much slower. Especially with long running queries. I already turned off the option "Verify on Every print" but that didn't help. When Googling I found many answer but they all target higher versions of Crystal Reports. An option like "verify stored procedure on first refresh" is not available in Crystal Reports 8.5. So how to disable that first request?

0

There are 0 best solutions below