ssrs 2008 use stored procedure

  • When I use the SSRS 2008 r2 report wizard, I can not find a way to setup a stored procedure to pass a parameters to the report. When I setup the report, the only way to get a query is to build query.

    I want to use a stored procedure since I want the user to enter a start date and an end date?

    Thus can you tell me how to use the report wizard initially to usesetup a stored procedure that requires input parameters? If this is not possible, can you tell how how to change the code and/or the designer so I can use a stored procedure in the report that was setup using the report wizard initially?

  • I may be misunderstanding but in the query designer enter:

    Exec YouRStoredProcedure (@Param1, @Param2)

    Andy

    ==========================================================================================================================
    A computer lets you make more mistakes faster than any invention in human history - with the possible exceptions of handguns and tequila. Mitch Ratcliffe

  • SSRS will not build a stored procedure for you. First you have to build the SP in SSMS or somewhere and then use it in your report. I never use the wizard so I don't even know if an SP data source is possible via the wizard.

  • How will the ssrs report know how to find the stored procedure? Do you need to set something else up?

  • When you create the dataset, there is an option to use a SQL Command/query or a stored procedure. Choose stored procedure and you will get a drop down box with the list of SPs on the box

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

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