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 |
|
bob123
Starting Member
16 Posts |
 Posted - 2010-02-23 : 19:35:39
|
| Hi, How do I pass user selected values to a stored procedure?Stored procedure provides data for RS 2005 report. |
|
|
pk_bohra
Master Smack Fu Yak Hacker
1182 Posts |
Posted - 2010-02-23 : 22:22:01
|
quote:
Originally posted by bob123
Hi, How do I pass user selected values to a stored procedure?Stored procedure provides data for RS 2005 report.
You mean you want to pass values only for some parameters of the SP. In that case you can provide default values for the parameter (optional parameters) in the SP definition.Regards,Pramod |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2010-02-24 : 10:05:24
|
| you need to add relevant parameters to your report procedure and then link parameters to report parameters to pass its value down.------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
how to pass user selected parameters to sp