May 17, 2012 at 7:44 am
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?
May 17, 2012 at 7:57 am
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
May 17, 2012 at 9:16 am
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.
May 17, 2012 at 10:52 am
How will the ssrs report know how to find the stored procedure? Do you need to set something else up?
May 17, 2012 at 10:59 am
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