Chris,You still don't have to do this in your application. What you can do is instead of a combo box you can have a text box in reporting services. The text entered into the text box could be your parameter. For instance, on the report properties have that text box with the label ("Enter values seperated by ',':"). This will at least help most of your users enter multiple values and seperate them via a ','. Then you can use the CSV list as a parameter to the report:....AND(@WBS IS NULL OR dbo.IssueWBSElements.WBS IN (SELECT IntValue FROM dbo.CsvToInt(@WBS)))And CsvToInt:CREATE Function dbo.CsvToInt ( @Array varchar(1000)) returns @IntTable table (IntValue int)--Parse comma seperated value parameters--To be used in SELECT blah WHERE blah IN (...)--This function returns int, but may be modified to return any datatypeASbegin declare @separator char(1) set @separator = ',' declare @separator_position int declare @array_value varchar(1000) set @array = @array + ',' while patindex('%,%' , @array) <> 0 begin select @separator_position = patindex('%,%' , @array) select @array_value = left(@array, @separator_position - 1) Insert @IntTable Values (Cast(@array_value as int)) select @array = stuff(@array, 1, @separator_position, '') end returnendThanks to nr for posting the CSVToInt procedure...
Keeping the web experience alive -- [url]http://www.web-impulse.com[/url]Imperfection living for perfection -- [url]http://jhermiz.blogspot.com/[/url] 
Multiple selection from drop down?
Posted - 2005-04-18 : 12:32:37
