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.