Hi friends ,
I want to create a Crystal report in C# using Parameterised Storred Procedure
This is my Stored Procedure
ALTER proc [dbo].[sp_employeReport]
(
@fname varchar(50),
@lname varchar(50),
@team varchar(50),
@rep varchar(50),
@status int,
@level varchar
)
As
Begin
Declare @Sql Varchar(8000)
set @Sql=' SELECT StaffId,FirstName,LastName,TeamName,LevelName,Empl oyee.Status from team,levels,leveldetails,Employee Where Levels.levelId=Leveldetails.levelId and Employee.StaffId=LevelDetails.Employeid and Team.TeamId=LevelDetails.TeamId '
If @fname <>''
Set @Sql = @Sql +' And FirstName like ''' + @fname +'%'''
If @lname <>''
Set @Sql = @Sql +' And LastName like ''' + @lname +'%'''
if @team<>0
set @Sql=@Sql+' And Team.TeamID = '''+ @team + ''''
if @rep<>0
set @sql=@sql+' And RepOfficer ='''+@rep+''''
If @status <>2
Set @Sql = @Sql +'And employee.Status =''' + Ltrim(@status)+''''
if @level<>0
Set @Sql = @Sql +'And levels.levelid =' + @level
Exec(@Sql)
PRint(@Sql)
End
I passed 5 parameters . How can i create a cristal report using this stored procedure and pass parameters to it
Thanking u & Regards
Balu