Hi,
I am using Crystal Reports with .NET 2.0 for generating reports in my project. My database is SQLSERVER 2000.
I want to display list of absentees between 2 given dates.
For this I have written a stored procedure like below.
CREATE procedure tesk4(@Fromdate DATETIME, @Todate DATETIME)
as
declare
@return BIT
WHILE @Fromdate <= @Todate
BEGIN
SET @Fromdate = @Fromdate + 1
if DATENAME(WEEKDA Y, @Fromdate) IN ('saturday', 'sunday')
print'saturday'
else
if @Fromdate IN (select holdate from holidays )
print 'Holiday '
else
select card_no from carddata where card_no Not in(select card_no from swipes where sdate =@Fromdate)
END
GO
Now how call this procedure in report as it have parameters.
Pls help me with a solution for this problem
I am using Crystal Reports with .NET 2.0 for generating reports in my project. My database is SQLSERVER 2000.
I want to display list of absentees between 2 given dates.
For this I have written a stored procedure like below.
CREATE procedure tesk4(@Fromdate DATETIME, @Todate DATETIME)
as
declare
@return BIT
WHILE @Fromdate <= @Todate
BEGIN
SET @Fromdate = @Fromdate + 1
if DATENAME(WEEKDA Y, @Fromdate) IN ('saturday', 'sunday')
print'saturday'
else
if @Fromdate IN (select holdate from holidays )
print 'Holiday '
else
select card_no from carddata where card_no Not in(select card_no from swipes where sdate =@Fromdate)
END
GO
Now how call this procedure in report as it have parameters.
Pls help me with a solution for this problem
Comment