How To use a stored procedure in a crystal reports 8.5?

I have to make a new report using crystal report8.5 . I have created a stored procedure in SQL Server 2005. The stored procedure has one input parameter.

Now I wanna to know that how I can add that stored procedure and show its result in my report while designing that re开发者_如何学Cport?

thank you

First go to File > Options > Database (going from memory) and make sure the checkbox for Stored Procedures is ticked. Then, when you setup your connection to SQL Server, as well as a Tables section you'll see a Stored Procedures one beneath it. Find your stored procedure in the list, add it as the data source for your report, and you'll be able to use it as a normal source.