Post reply

Date Parameters don't work

  • April 22, 2008 at 3:42 pm

    #181594

    i've got a daily report that linked to a stored proc with two date parms (begindate / enddate), when I run the query in the stored proc in sql, I get data for three days (2008-04-17 00:00:00; 2008-04-18 00:00:00; and 2008-04-21 00:00:00), but when I run the report in RS, it only shows one date (4/21/2008). Although I uncheck NULL for both date parms and enter a beginning and ending date and run it, it only returns data for date 4/21/2008.

    Does anyone have any idea of what I may be doing wrong?

    thx,

    John

  • April 22, 2008 at 9:52 pm

    #805856

    Hii latingntlman,

    Can you please tell me how you are trying to access the date parameters on your report...?? I mean to say..if you are trying to print the respective date parameters inside a textbox then how you are writing an expression for it...??

    Thanks,

    Niraj

  • April 22, 2008 at 10:28 pm

    #805862

    Hi

    Try to use this when u are using date parameter in RS:

    Format(Cdate(Parameters!Dateparameter.Value),"MM/dd/yyyy HH:mm"), it will work i suppose.

    Thanks

    Meghna

Viewing 3 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply