Hi!

I have CR11 and SQL Server 2005. I created Stored Procedure to Delete all records from table and than base on Select Statement Insert back to this table new records base on parameter sent from Crystal Report. Later, I use this table as a Data Source for other report.

I created report base on this Stored Procedure and created Parameter in this report. However, when I run the report it just Alter Stored Procedure and do not run it. (do not' execute the script for Delete and Insert).

Any suggestions how to handle this situation? Thanks at advance.

Alec.