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 |
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
 Posted - 2009-08-31 : 10:50:18
|
| I have a parameter on my report. We just changed the type to be a Multi-Valued parameter. When it was a single value it displayed on the report heading just fine with the following:=Parameters!Department.ValueNow the user would like to select multiple values so we changed the where clause from=@Department to IN (@Department)my =Parameters!Department.Value now shows #Error because it is now being ppassed an array. Changing the value to:=Parameters!Department.Value(0) Displays the first value selected. Is there a way to display the entire array selection or do I need to create a placeholder for a max number of entries?=Parameters!Department.Value(0) + ", " + Parameters!Department.Value(1) +", " + Parameters!Department.Value(2) + ", " + Parameters!Department.Value(3)...Department.Value(30)John"The smoke monster is just the Others doing barbecue" |
|
|
JCirocco
Constraint Violating Yak Guru
392 Posts |
Posted - 2009-08-31 : 10:59:03
|
| I found this in an MSDN article and it seems to work.=Join(Parameters!Department .Value,", ")John"The smoke monster is just the Others doing barbecue" |
 |
|
|
|
|
|
Report Parameter Array display on report