Error with using SQL Server stored procedure in crystal report ...

[request]

I have used the stored procedure that I created in SQL Server in my crystal report.

However, when I am trying to run the report, it gives me the following error message:

General SQL Server Error: Check MEssages From the SQL Server.
Error Detected By Database DLL.

WHY AM I GETTING THIS ERROR???

Also, in the stored procedure I have created a temp table as ##temp_coll. I have a select statement in my stored procedure as
select * from ##temp_coll

Please help.

Thanks.

 

[view]

Did you test your stored procedure in the SQL Server Query Analyzer by using the EXEC SPName 'parameter' to catch any problems?