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 |
|
rwlopez
Yak Posting Veteran
80 Posts |
 Posted - 2006-10-10 : 17:13:13
|
| A have a report in Reporting services that uses parameters. I would like to pass a parameter from the report to the query that contain more that one value, but I do not know how to accomplish this. Here is an example. I would like to run a Sales report for California where the user selects the state and all three sales region codes are passed to the query. Does anyone know a simple way to accomplish this?Sales Region Codes for California117202172131722Sales Region Codes for Nevada117541175511759 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
rwlopez
Yak Posting Veteran
80 Posts |
Posted - 2006-10-12 : 12:17:38
|
| Thanks I will try it. |
 |
|
|
candyme
Starting Member
4 Posts |
Posted - 2006-10-16 : 04:37:44
|
| set sales region code as a multi-value parameter (RS 2005)Gerri |
|
|
|
|
|
|
Parameters