Post reply

Stored Procedure does not pass the data to SSRS Reports

  • January 30, 2013 at 2:16 am

    #273464

    HI All,

    I have Stored Procedure that is being used by SSRS report as the source... When I select the custom calendar dates and view the report, the report shows no data...

    The query in the SP works fine if I explicilty place the query in SSRS query window....only when viewing the report access the stored proc and while viewing the report it shows no data. Im sure this problem is related to date paramter.

    The Parameter selected in calendar custom date is in this format

    1/29/2013 00:00:00 ie mm/dd/yyyy hh:mm:ss

    The data available in database is in this format YYYY/mm/dd hh:mm:ss...

    Could any one please let me know what should be dateformat in SP to fetch the data via SSRS

    Thanks

  • January 30, 2013 at 4:03 am

    #1582545

    Please select parameter type is datetime.

  • January 30, 2013 at 4:10 am

    #1582546

    Thanks for you reply.

    My Paramater time is datetime only.... I have not changed anythin wrt reporting side....everythig is the same...just instaed accessing the query directly, I had created a SP.

    The same report shows data if the report access the query directly...but whereas no data is returned when it comes via SP....

    Not sure why...any help?

  • January 30, 2013 at 5:37 am

    #1582560

    in Stored procedure also declare @var datetime

    ---

    ssrs

    exec S_t @Date

    Sql server

    Create Proc S_t(@Date datetime)

    as

    select * from table_name)

    where date in(@Date)

    end

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

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