SQL Server Performance

Crystal report in C# , stored procedure

Discussion in 'SQL Server Reporting Services' started by mastersql, Aug 24, 2007.

  1. mastersql New Member

    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)
    select PlugPercentage,TimeInspected from statistic where RecordNo =
    @RecordNo and TimeIninterval between(@startDate) and (@endDate)

    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.

    Ever Smiling
  2. satya Moderator

    Why not check under C# related forums in this regard, I don't see involvement of SQL here.
  3. mastersql New Member

    Ok I will try There
    thanks for reply
    Ever Smiling
  4. richardalgor New Member

Share This Page