How do you setup a multivalue parameter in sql server reporting services 2000?

Hi There,

I am using SQL Server Reporting Services 2000 and need to create a parameter that will allow a user to enter values separated by a comma (Ex, 12345,6789,54321....). How can this be accomplished? I am suing Visual Studio 2003 Query designer to create the reports.  i found this link which uses the strip function and a stored procedure but i don't have any stored procedures. Is there a way I use this function and then call it from my query? Please see my query and if possible enter the call to the function for me and let me know where in the report designer to copy and paste the function. I thought it would go under the CODE tab in Report Properties but I'm not sure.

I want the parameter to search on mh.mobile_id

http://bisqlserver.blogspot.com/2007/02/using-multi-value-parameters-in-stored.html

Thanks in advance for your help,
R

SELECT   mh.mobile_id, 
	mv.INMARSAT_ISN, 
	mh.SDATE AS Start_Date, 
	to_char(mh.EDATE, 'DD/MM/YYYY') AS End_Date, 
              SSM.FIRST_name || ' ' || ssm.last_name AS Sales_Manager, 
	mv.terminal_group_code, 
	tg.terminal_group_name
FROM      mobile_history mh, 
	CSS_TERM_GROUP_MOBILE_ID_MV mv, mobile m, 			CSC.CSCS_NLR_TERMINAL_GROUPS@DBLINK_CSS_CSSRO tg, 
              CSC.CSCS_SALES_SUPPORT_MANAGERS@DBLINK_CSS_CSSRO ssm
WHERE    SYSDATE BETWEEN sdate AND edate 
	AND inmarsat_imn = m.mobile_id 
	AND mh.mobile_id = m.mobile_id 
	AND mh.MOBILE_ID = mv.INMARSAT_IMN 
	 AND mv.TERMINAL_GROUP_CODE = tg.TERMINAL_GROUP_CODE 
	AND tg.sales_support_manager_id = ssm.support_manager_id
ORDER BY 5 DESC

Select allOpen in new window