stored procedure with report wizard 2008 r2
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 17th, 2012 9:28am
Hi, I'm not sure that you can use a stored procedure on the wizard. What you can do is put any temporary query that the report can use. Once the wizard ends, then go to Report Data. If you don't see it, go to View/ Report Data. There you are going to see the Data Source and Data Sets. The data set is the one that will contain the query that you inserted originally. Inside there it will give you the option to select a stored procedure. Note that in that same screen there is a parameter option, where you can assign parameters that you already have to your procedure. SSRS will also automatically create new parameters that you can use on your report. This information is if you are using Visual Studio. hope it helps. qdtb
May 17th, 2012 11:32am