problem in generating crystal report in .net

Collapse
X
 
  • Time
  • Show
Clear All
new posts
  • sreedivya
    New Member
    • Jul 2007
    • 14

    problem in generating crystal report in .net

    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
  • victorantos
    New Member
    • Dec 2007
    • 3

    #2
    You should better use new reportform control from .net
    you don't need to install anything reporting services or crystal reports it just works

    Comment

    Working...