CR 8.5 Executing Stored Procedure twice before generating the Report

[nikhilr]

Hi,

I am getting a strange problem with Crystal Report 8.5
The report uses a stored procedure (SQL Server) to get the data.

In the stored procedure before executing the select query some inserts are done in some other tables.

When the report is executed through Crystal Reports it executes the stored procedure twice.

I am unable to figure out why this could be happening.

 

[vidru]

Make sure 'Verify on Every Print' isn't checked in the Database menu. Anytime a 'Verify Database' happens, the procedure will be re-run, hence your double execution.

-dave