Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
scamper
Yak Posting Veteran
52 Posts |
 Posted - 2012-05-17 : 09:40:58
|
| 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? |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-05-19 : 15:06:54
|
| you need to give stored procedure name in dataset properties and set command type as stored procedure. Then click execute icon and it will prompt for parameters in proc. enter values and execute to populate datagrid with values. On refreshing the parameter details will get automatically added to report. Go to parameter tab and change properties if you've to make parameter a dropdown with values from another dataset------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
 |
|
|
|
|
|
ssrs 2008 use stored procedure