Post reply

stored procedure problem in SSRS

  • January 3, 2008 at 9:05 am

    #185142

    Hi all,

    I am trying to run parametered stored procedure on the SSRS but it does not work and still ask me for the input!!! I also have selected stored procedure on command.

    sp_test_records @starttime,@endtime and defined @starttime and @endtime in report parameter.

    but after that when i try to preview and enter starttime and endtime, it fails with stored procedure expected value for @starttime!!

    how can i solve this!!

  • January 3, 2008 at 7:11 pm

    #764630

    Check the spelling of @StartTime in the proc... notice... 2 "T's" in your exec... does it have 2 "T's" in the proc?

    --Jeff Moden

    RBAR is pronounced "ree-bar" and is a "Modenism" for Row-By-Agonizing-Row.
    First step towards the paradigm shift of writing Set Based code:
    ________Stop thinking about what you want to do to a ROW... think, instead, of what you want to do to a COLUMN.

    Change is inevitable... Change for the better is not.

    Helpful Links:
    How to post code problems
    How to Post Performance Problems
    Create a Tally Function (fnTally)

  • January 4, 2008 at 4:45 am

    #764763

    u might want to check the parameter datatype in report parameters screen, chances are the parameter has string as the datatype and ur passing a datetime value.

    Jayanth Kurup[/url]

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

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