Stored Procedure not appearing in Crystal report

When you try to access the stored procedure that you created from Database Expert in Crystal Report, you’ll discover that your stored procedure doesn’t appear in the list. In order to make it appear you must grant Crystal Report the permission to execute.

GRANT EXECUTE ON mystoredprocedure TO PUBLIC

I got the solution from here: using Stored Procedure for crystal report. Its written in detail. Hope it helps