Hi Pujitha,
This usually means the account Crystal Reports is using to run the Stored Procedure does not have permissions to create the temp table in the procedure.
Make sure you have the proper permissions. Try running the Stored Procedure in the database with the same Crystal Reports account and see if you get the same message.
Brian
Add comment