how to add a multi value select prompt

Thanks Wayne for the useful information but i am experiencing another
problem
I am not able to add a prompt in the reportwhich can allow multiple
values,
as in, if i want to write a query
select * from departments where departmentid in (@.PromptName)
i want to see the data for more than 1 departments, but if i specify a
comma separated list in the prompt, it gives me an error.......
please tell me if there is another way of doing so.Check
http://solidqualitylearning.com/blogs/dejan/archive/2004/10/22/200.aspx.
--
Dejan Sarka, SQL Server MVP
Associate Mentor
www.SolidQualityLearning.com
"Gunjan jain" <gunjan@.nagarro.com> wrote in message
news:f8d018ec.0501172039.59a24cd2@.posting.google.com...
> Thanks Wayne for the useful information but i am experiencing another
> problem
> I am not able to add a prompt in the reportwhich can allow multiple
> values,
> as in, if i want to write a query
> select * from departments where departmentid in (@.PromptName)
> i want to see the data for more than 1 departments, but if i specify a
> comma separated list in the prompt, it gives me an error.......
> please tell me if there is another way of doing so.