Please follow the below steps to connect the Crystal Report with stored procedure.
1. Add Crystal Report and give suitable name to it.
2. Now select As a BlankReport from the dialog.
3. Then Inside the Field Explorer window right click on Database Fields and select Database Expert... option.
4. Now in the wizard expand Create New Connection.
5. Then expand OLEDB(ADO) option and right click on it and select Make New Connection.
6. Now select Microsoft OLEDB Provider for SQL Server and click on Next.
7. Now fill the connection details and click Next.
8. Now the configuration is done and the database will shown.
9. Expand the database and you will see the Tables, Views abd Stored Procedures.
10. Select the procedure and add it and click Ok.
11. Finally the Field Explorer will display the procedure and the Columns.
Now use the Columns to design your report.
