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 |
|
DLTaylor
Posting Yak Master
136 Posts |
 Posted - 2007-06-29 : 09:05:11
|
| I and trying to get some help with Multi-Value parameters in Reporting Services 2005 in VS 2005.I’m new to the product and struggling with the TSQL syntax.(I have simplified my SQL statement for the purposes of this question)I have a dataset below which has 1 parameter;="SELECT * " &" FROM dbo.Table" & Iif(Parameters!Sex.Value = "ALL",""," AND dbo.Table.Sex = '" & Parameters!Sex.Value &"'" )The Sex parameter dataset contains F, M, U and ALL – the above parameter allows me to select on any of the 4 options.I would like to use the multi-value parameter but am struggling to grasp the syntax. Believe me I have tried a few things.Could someone provide me with an idiots guide on how to make my basic parameter a multi-value parameter?Any help would be great. |
|
|
dineshasanka
Yak Posting Veteran
72 Posts |
Posted - 2007-07-08 : 09:36:26
|
| http://msdn.microsoft.com/msdnmag/issues/06/06/DataPoints/default.aspxRead the multivalue parameter section |
 |
|
|
|
|
|
multi-value parameters