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

Question

Hi all.... 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 report?

thank you

Answer 1

This may help you

a) Loading Crystal Report reports which use Stored Proc in C#

b) How do I pass the required parameters of a Stored Procedure in Crystal Reports?

Answer 2

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.