Crystal report in C# , stored procedure Dear Friends, I want to create a Crystal report in C# using Parameterised Storred Procedure This is my Stored Procedure CREATE PROCEDURE sp_percentageGraph ( @RecordNo INT, @startDate varchar(40), @endDate varchar(40) ) AS BEGIN select PlugPercentage,TimeInspected from statistic where RecordNo = @RecordNo and TimeIninterval between(@startDate) and (@endDate) return END GO I passed 3 input parametrs. How to use this storedprocedure to my C# program and pass the parameters to the crystal report. The user would change the timeinterval and recordNo. According to change the timeinverval and Recordno we want my report I am new to this. If any one knows please let me know....if sample C#, Storedprocedure source code would be greatly appreciate. Thanks Ever Smiling Ashish
For passing parameter to crystal reports use the following link http://csharp.net-informations.com/crystal-reports/csharp-crystal-reports-date-parameter.htm and execute stored procedure with parameter http://net-informations.com/csprj/data-providers/cs-procedure-parameter.htm hope above links will help you. Richard.